View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default 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.