That works as well, thank you

"muddan madhu" wrote:

try this

=SUM(1/COUNTIF(A2:A7,A2:A7)) ( use ctrl + shift + enter )


On Nov 24, 6:29 pm, PA wrote:
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