|
A partire da gennaio 2021, i tipi di file classici non potranno più essere utilizzati. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

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

Completato
Richiedi una demo
  • Modificato

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.

 

 

 

5

Commenti

14 commenti

Data Voti
  • Commento ufficiale
    Mike Davis

    The UNIQUE formula is now supported in Spreadsheets. Thanks for your patience and feedback along the way. We couldn't have done it without you!

  • Liz Habel

    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 Habel,

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

    1
  • Mike Davis

    Happy to get you added Vishnu Teja!

    1
  • 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)),"")
    1
  • Mike Davis

    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
  • Katherine Korol

    Mike Davis Can you add me to this request as well?

    0
  • MacKenzie Schrotenboer

    Katherine Korol Happy to get you added!

    0
  • Mike Davis

    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!

    0
  • Fatima Smounat

    Mike Davis Can you add me to this request as well?

    1
  • Mike Davis

    You bet Fatima Smounat!

    0
  • Danny Sneath

    awesome

    0
  • Imole Babaniji

    Eagerly awaiting this enhancement.

    0
  • Brooke Mortvedt

    Imole Babaniji Thanks for commenting! I have you added to this feature request so you will receive updates!

    0

Accedi per aggiungere un commento.