Autofilter vs Function

[Ody]

Hello all,

I'm using the following function to find unique values in my table:

=IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Unique")

The number of unique records I get vs using the autofilter sort for unique records differs by 35. Any suggestions as to why there is a discrepancy? I confess, I'm a little vexed.

Thanks for any input!

 

[andiemac]

Your formula includes "$C$1:C1" which I am assuming you fill down. As the range changes for each cell it would be possible that a record is unique for the range "$C$1:C10" but then have a dupe in range "$C$1:C11".