Removing Duplicates in Excel - AdvantEdge Training & Consulting

Removing Duplicates in Excel

 Removing duplicate information can be both helpful and intimidating when working with many line items in Excel.

Follow these steps to make the process easy :

  1. Ensure your data has column headers and that there are no blank columns or rows between data you want selected and checked.
  2. Click anywhere inside the data you wish to have checked for duplicates. (Once you click the Remove Duplicates command, all data will be selected.) Removing Duplicates in Excel - data
  3. Click the Remove Duplicates command, located on the Data tab, in the Data Tools group. This will select the rest of the data. Removing Duplicates in Excel - Click button
  4. A dialog box will pop-up, allowing you to select the columns you want compared for duplicates. It is a best practice to have more selected, rather than fewer, as more criteria will keep the wrong records from being removed. (ex.: If I only chose last name and first name, then there is a good chance I will delete a row that was not actually a duplicate, as there might be more than one person with the same first and last name.) Removing Duplicates in Excel
  5. Once you click the OK button, it will let you know how many duplicates were deleted.  Removing Duplicates in Excel - results
Learn more was to make Excel less intimidating and your work easier by taking an Excel class with AdvantEdge Training.
If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top