Remove Duplicate Records

Delete repeated rows and keep one copy of each.

You will learn to

• Use Remove Duplicates on a list

How it works

Select your data and choose Data → Remove Duplicates. Pick the columns that define a duplicate; Excel keeps the first occurrence and deletes the rest.