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