ssblue
asked on
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
Example - column A has 6 unique name / it has a total of 9 names
mike
sue
sis
tin
sue
Mike
sam
joe
tin
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could use AdvancedFilter to copy unique names to another column and count the results
Unique-Names-Count.xlsx
Unique-Names-Count.xlsx
ASKER