See:
http://www.cpearson.com/excel/Duplicates.aspx
scroll down to:
Counting Distinct Entries In A Range
--
Gary''s Student - gsnu200743
"raul acosta" wrote:
Frequently I have to use a pivot table to count first column unrepeated
elements. Is there a function to do this?