Hi,
Try this but have a look at this page which discusses the merits of various
ways of doing this. And BTW doesn't like this method
=SUMPRODUCT((A5:A2000"")/COUNTIF(A5:A2000,A5:A2000&""))
http://www.sulprobil.com/html/count_unique.html
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"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.