Count unique names in a list
 

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

Count unique names in a list
 

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

Count unique names in a list
 

For range of B1:B20.

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


"Cassie" wrote:

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

Count unique names in a list
 

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

"Brad Vogt" wrote:

For range of B1:B20.

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


"Cassie" wrote:

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

Count unique names in a list
 

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


.

Count unique names in a list
 

I know!

--
Biff
Microsoft Excel MVP


"Mike H" wrote in message
...
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


.