Counting Different Names in A Column... Formula?

[Mhz]

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..

[Ron Coderre]

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

[Mhz]

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

Thank You Very Much!