Count names in column once
 

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?

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


"Lorraine" wrote:

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?

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.
"Lorraine" wrote in message
...
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?

Or if you dont want a meesage, have a message! lol (:
"Alan" wrote in message
...
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.
"Lorraine" wrote in message
...
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?