View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PA PA is offline
external usenet poster
 
Posts: 101
Default Count, ignoring duplicates

I have a column with many duplicates. I need to get a count of each
individual record, ignoring the dupes so that
x
x
y
z
z
z
would yield a count of three. There are many more, spanning from G2:G9075.
Thanks
Paul