Count unique names in a list

[Cassie]

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

 

[T. Valko]

One way...

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

 

[Brad Vogt]

For range of B1:B20.

=SUMPRODUCT((B1:B20<>"")/COUNTIF(B1:B20,B1:B10&""))

 

[Cassie]

Brad

Thanks this works fine

What would the formula be if I also needed to count all the unique names by
month. The months are in col c. the names appear multiple times in the file
at least once in each month - I only want to count John Smith once in January
but his name appears 4 times.

Cassie

 

[Mike H]

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]

I know!

--
Biff
Microsoft Excel MVP

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.