EXCEL TIP

Deleting Duplicate Rows In Excel

How to delete rows that are duplicates—that is, rows that match in multiple columns like Last Name, First Name, House Number, and Street Name? It’s surprisingly simple. What you do is make a copy of your data that leaves out the duplicate rows. Click somewhere in the data area. Select Data | Filter | Advanced Filter from the menu. Check the Unique records only box. Click OK. This hides all the duplicate rows. Highlight the slimmed-down data area. Copy/Paste the data to a new location. The copy will omit the hidden rows, so you now have a version of your data with no duplicates.