count

[hemusta]

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

 

[Mike H]

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

 

[T. Valko]

Try this:

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

 

[Shane Devenshire]

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.