Easiest would be to use datafilteradvanced filter, copy to another
location and unique records only, then count the extracted list

=COUNTA(extracted_range)


or use a formula

=SUMPRODUCT((A1:A22000<"")/COUNTIF(A1:A22000,A1:A22000&""))


Regards,

Peo Sjoblom

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