He's behind you
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"T. Valko" wrote:

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


.