Is there a function that counts distinct number od records in a ra
 

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.

Is there a function that counts distinct number od records in a ra
 

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.

Is there a function that counts distinct number od records in a ra
 

John Walkenbach has a few solutions with the best you can count the unique
items then once the count is found they can be listed. Try,

http://www.spreadsheetpage.com/index...rray_or_range/


HTH
Peter

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

Is there a function that counts distinct number od records in a ra
 

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.