Hi All,

I'm trying to make this work but with no luck:

B1
=countif($A1:A1,A1)>1
evalutes to TRUE for all but the first instance of each entry in the column, copy this formula down alongside your data, then filter it for 'true' then delete the records

Any idea what would prevent it from working? It is returning all values as FALSE though I know some should be TRUE.