One way...

=SUMPRODUCT((A2:A20<"")/COUNTIF(A2:A20,A2:A20&""))

--
Biff
Microsoft Excel MVP


"Cassie" wrote in message
...
hi
How do I count a list of names, some names appear more than once. I only
want to count unique names.
I use excel 2007
Thanks
Cassie