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?