count
 

I have a spreadsheet with a couple of hundred names entered once, twice or
three times. Now I want to count the how many different names there are.

How do I do so.

Thanks

Henk

count
 

Hi,

Try this with the range altered to suit. Note the range cannot contain blank
cells

=SUM(IF(FREQUENCY(MATCH(A1:A10,A1:A10,0),MATCH(A1: A10,A1:A10,0))0,1))

Mike

"hemusta" wrote:

I have a spreadsheet with a couple of hundred names entered once, twice or
three times. Now I want to count the how many different names there are.

How do I do so.

Thanks

Henk

count
 

Try this:

=SUMPRODUCT((A1:A200<"")/COUNTIF(A1:A200,A1:A200&""))

--
Biff
Microsoft Excel MVP


"hemusta" wrote in message
...
I have a spreadsheet with a couple of hundred names entered once, twice or
three times. Now I want to count the how many different names there are.

How do I do so.

Thanks

Henk

count
 

Hi,

This doesn't cover all the bases but may meet your needs:

=SUMPRODUCT(1/COUNTIF(C1:C9,C1:C9))

Where C1:C9 is the range with names.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"hemusta" wrote:

I have a spreadsheet with a couple of hundred names entered once, twice or
three times. Now I want to count the how many different names there are.

How do I do so.

Thanks

Henk