Here is one way,

=COUNT(IF(FREQUENCY(A:A,A:A),1))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"RPC@Frito" wrote in message
...
I'm using Excel 97 and have a list of names. The entire list is 22,000
rows
or so, and all the names in the list are repeated numerous times (it's
downloaded data). I don't want to delete all the duplicates but want to
be
able to count how many distinct names there are in the list.

Any solutions out there?

Thx.