Forum Discussion

Copper Contributor

Mar 19, 2020

count distinct text values and name them

Good afternoon, I have checked other conversations but couldn't find the solution for the problem I'm having, please let me know if you have any ideas: - I have a file with a column of input dat...

excel

Formulas and Functions

Piotr_AG

Copper Contributor

Mar 19, 2020

Savia thank you for your answer,

- UNIQUE works perfect! thats exactly what I was looking for!

- the COUNTIF calculates all of the types with "A" in this case 11 - as these repeat, but I would like to get the number of distinct types with "A" - (in this case theres only 1 type: "type_1A"). How could I do this?

Thanks!

Savia

Iron Contributor

Mar 19, 2020

Just do the COUNTIF on your list of unique labels instead of on the full list.

Piotr_AG
Copper Contributor
Mar 19, 2020
Savia Didn't expect it to be that simple, thanks!