count of unique values

I have a list of names and I need a count of unique names.

Example - column A has 6 unique name / it has a total of 9 names

mike
sue
sis
tin
sue
Mike
sam
joe
tin
ssblueAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

pls try something like this
=SUMPRODUCT(--(FREQUENCY(MATCH(A1:A9,A1:A9,0),ROW(A1:A9)-ROW(A1)+1)>0))

Open in new window

Regards
0
 
Rob HensonFinance AnalystCommented:
If you create a pivot table on the data and use name as a Row header, it will create only one row per name; you can then count those.
0
 
ssblueAuthor Commented:
Thanks!
0
 
Roy CoxGroup Finance ManagerCommented:
You could use AdvancedFilter to copy unique names to another column and count the results
Unique-Names-Count.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.