See:
Counting Distinct Entries In A Range
in:
http://www.cpearson.com/EXCEL/Duplicates.aspx
--
Gary''s Student - gsnu201001
"Ayo" wrote:
I am looking for a way to tell how many distinct values are in a range. For
example, say I have values in Range A5:A2000 and I want to know of those 1995
cells how many distinct values are in the range.