Counting Different Names in A Column... Formula?

  • Thread starter Thread starter Mhz
  • Start date Start date
M

Mhz

Just wanted to know if there is a Formula that can count DIFFEREN
names
in a Column?

eg.

There may be more than 1 same name, but I dont want it counted twice:

James
Edward
Max
John
David
James
James
Lisa

Total should = 6 (Since James is 1 person)

Is there a formula to solve this type of count? Thanks for any hel
on this.
 
Try this

For a list of names (with possible multiples) in A1:A10

This formula returns the count of unique items:
B1: =SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))

Does that help?

Regards,

Ro
 
Back
Top