Forum Discussion
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...
Piotr_AG In Office 365, you could create your unique list automatically with =UNIQUE(A3:A33). Outside of that, you could copy and paste the list to a new location and then use Data => Remove Duplicates.
To count the number of types with an A in them - you can do: =COUNTIF(A3:A33,"*a*").
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!