Create a Helpler column
=COUNTIF($A$2:A2,A2)=1
AutoFilter all the FALSE
Select all the filter range then go to menu select Edit Delete Rows


"Jess" wrote:

I have a spreadsheet with over 3000 records. Is there a way to auto delete
any duplicate records? Please help! Thanks