Select the complete table, choose Data → Remove Duplicates, then select the columns Excel should compare.
Visual walkthrough
Data›Remove Duplicates
Before
The table contains repeated record IDs.
After
One record remains for each selected key.
Check the result
Compare row counts and spot-check the retained records.
Step-by-step instructions
- Make a copy of the worksheet before removing records.
- Select the complete table and choose Data → Remove Duplicates. Confirm My data has headers when appropriate.
- Select only the comparison columns. Choose a record ID for unique IDs, or several columns when the whole combination defines a duplicate.
- Choose OK and read the number of removed and remaining records. Check a few examples against the original sheet.
Frequently asked questions
Why are duplicates still present?
Check for extra spaces, inconsistent characters and differences in columns selected for comparison. Two rows are duplicates only under your chosen comparison.
Reference: Microsoft Support