Eliminating Duplicate Lines in an Excel Table
Removing duplicate values in an Excel table doesn't have to take hours of your time.
by Thomas Duff, Sandra Mahan on 6/23/2016
duplicate rows, Excel, one minute office magic
Excel is a great way to build tables of data, but sometimes you need to make sure you don't have any duplicates in your data. That may be easy if you only have a dozen rows, but what if you have thousands?
It's very simple… use the Remove Duplicates menu option!
Here I have a table of ten data rows, four of which are exact duplicates. I can delete those using Table Tools > Design > Remove Duplicates:
Original Excel spreadsheet with duplicates
Excel will ask you what columns you should use to compare duplicates. By default, it selects the entire row:
Options for removing duplicate rows
When you click OK, the duplicate rows are deleted and you now have unique table rows:
Modified Excel spreadsheet without duplicates
Topic: One Minute Office Magic