Count names in column once

L

Lorraine

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?
 
D

Duke Carey

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))
 
A

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