Counting Different Names in A Column... Formula?
 

Just wanted to know if there is a Formula that can count DIFFERENT
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 help
on this..


--
Mhz
------------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=571093

Counting Different Names in A Column... Formula?
 

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,

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=571093

Counting Different Names in A Column... Formula?
 

Yes Ron, That Solved My Question... The Unique Factor..:)

Thank You Very Much!


--
Mhz
------------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=571093