Thread
:
Count, ignoring duplicates
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
PA
external usenet poster
Posts: 101
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
Reply With Quote
PA
View Public Profile
Find all posts by PA