Thanks Domenic. This is the same suggestion i received from Ron - and it
works pefectly!

"Domenic" wrote:

If you download and install the free add-in Morefunc.xll, you can use
COUNTDIFF...

http://xcell05.free.fr/english/morefunc/countdiff.htm

Otherwise, try...

=SUMPRODUCT((Range<"")/COUNTIF(Range,Range&""))

Hope this helps!

In article ,
Bobby wrote:

I have a huge data extract that i'm trying to sort through. The first thing
I want to do is count the number of unique entries in a given column. For
example, in my extract a "name" comes up many times - i want to count how
many "unique" names I have on my data sheet, in a specific column. I'm
pretty sure this is easily done with pivot tables - but can't figure it out
myself. (the pivot table keeps summing stuff up - it's not "counting").