count

  • Thread starter Thread starter hemusta
  • Start date Start date
H

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
 
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
 
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.
 
Back
Top