Thread: Is there a function that counts distinct number od records in a ra
View Single Post
  #3  
Old March 19th, 2010, 08:03 PM posted to microsoft.public.excel.worksheet.functions
Billy Liddel
external usenet poster
  
Posts: 489
Default 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.