How do I remove duplicate records in Excel?
  • 27 Jan 2023
  • Contributors
  • Dark
    Light
  • PDF

How do I remove duplicate records in Excel?

  • Dark
    Light
  • PDF

Article summary

Frequently when I export data I get many rows with the same information.  For instance I have 5 rows all with the same name and I only need the row to appear one time.  How do I get rid of the extra rows without deleting them one by one?

Answer:
To remove the duplicate rows in Excel:

In Excel 2007, Excel 2010 and Excel 2013 there is a button called Remove Duplicates on the Data Menu ribbon.
1. Open your file in Excel.
2. Click on the Data Menu item.
3. Select the entire spreadsheet.
4. Click the Remove Duplicates item ( near the middle of the ribbon).
5. Select just the columns that contain the fields you want to de-dupe (e.g. Profile Name or idcode) and click OK.

The records remaining will be de-duped on the value(s) chosen.  You can then remove or hide columns that relate to the details of the records leaving just those you need.

Was this article helpful?