Count names in column once

[Guest]

Want to count the names in a column only once. The name may be repeated
several times such as Tom
Tom
Tom but I want to count it only once at
the bottom of the row. Is this possible in Excel?

 

[Guest]

Change the range to reflect your names. It is an array formula, so commit it
with Shift-Ctrl-Enter

=SUM(1/COUNTIF(A1:A10,A1:A10))

 

[Alan]

Yes,
Try something like
=IF(COUNTIF(A1:A1000, "Tom")>0, "The name 'Tom' exists in the list","")
Of course change the meesage displayed whether true or false to what you
want displayed,
Regards,
Alan.

 

[Alan]

Or if you dont want a meesage, have a message! lol