Remove those rogue records in Excel

 May 21, 2015

When lists of data are merged, duplicates can be introduced. Fortunately, Microsoft Excel has a Remove Duplicates feature that will eliminate these rogue records. All that is needed is a column or a set of columns that can be used to establish the duplicates.

Remove those rogue records in Excel

This list above has many duplicate records. Two are highlighted (Lonnie and Dwight).

We can remove duplicates based on the first name in this case as no two employees have the same first name. In reality, it would be likely for a list of first names to have duplicates, so a combination of first name, last name and some other criterion would be necessary to find the duplicates.

To seek out and destroy the duplicates:

  1. Click into the list.
  2. Go to the “Data” tab on the Ribbon and click “Remove Duplicates.”
  3. Deselect the columns that aren't going to be used to identify duplicates. Remove those rogue records in Excel
  4. Click OK.

In this case, 5 duplicates were found and removed. Remove those rogue records in Excel padding-left: 20px

How do your Excel skills stack up?   

Test Now  

About the Author:

Ben Kirk  

With over 16 years of experience working as a Desktop Applications specialist for a number of large education services providers, Ben is one of New Horizons most skilled and dynamic instructors. With his Advanced Diploma of Business Skills alongside his practical experience and expertise, Ben is able to provide insight and guidance to students at all skill levels across the entire Microsoft Office suite.

Read full bio