How can we list unique values from a range in a spreadsheet?
PlanowanyHi,
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.
-
Oficjalny komentarz
Great news! This enhancement is now on the roadmap and planned for work this year. We'll continue to take in requests here and will keep you apprised when this does get added to the platform. Thanks again for your feedback and have a great day!
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
Hey Liz Walters,
Can you add me to this request too? eagerly looking forward to this addition!
1
Happy to get you added Vishnu Teja!
1
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)),"")
1
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.
1
Mike Davis Can you add me to this request as well?
0
Komentarze
Komentarze: 10