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