Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

How can we list unique values from a range in a spreadsheet?

Request Demo
  • Edited

Hi,

I'm trying to list down all unique values from a column in a spreadsheet.

For eg. If I have the below list in the column in a spreadsheet:

A.

And I want to transform the column so that only the unique values are shown as below:

B.

 

Is there a formula in wdesk spreadhseet I can apply to achive this? i.e A formula to transform A. above to B?

 

Thanks.

 

 

 

2

Comments

5 comments

Date Votes
  • Liz Walters

    Hi Kevueli,

    Thanks for your question! It sounds like a UNIQUE formula may be helpful here, but unfortunately, wdesk does not have that capability today. I will add you to the request for that feature and share your feedback with our product team. We'll keep you updated on any advancements!

    0
  • Vishnu Teja

    Hey Liz Walters,

    Can you add me to this request too? eagerly looking forward to this addition!

    0
  • Mike

    Happy to get you added Vishnu Teja!

    0
  • Juan Bosco Garcia de Madariaga Orejas

    Hello! Are there any news in this topic? I'm trying to get an alternative formula in order to get unique values, but it ain't working:

    =IFERROR(INDEX($A$2:$A$9,MATCH(0,INDEX(COUNTIF($C$1:C1,$A$2:$A$9),0,0),0)),"")
    0
  • Mike

    Hi Juan!

    Thanks for chiming in. As far as the UNIQUE formula, that is is only a proposed suggestion at this point but we do continue to take in requests for it and I will surely add you to our list as well.

    Regarding this question, let me check with our experts on why that formula would fail for you as we do support IFERROR, INDEX, MATCH and COUNTIF. I'll let you know what I found out ASAP.

    0

Please sign in to leave a comment.