1. Computing

Remove Duplicate Data Records in Excel

Remove Duplicate Data Records Quick Tutorial

By

Remove Duplicate Data Records in Excel

Remove Duplicate Data Records in Excel

© Ted French

Note: If you have limited experience with Excel try the Remove Duplicate Data Records Step by Step Tutorial which includes detailed information about using this feature.

This tutorial is intended for users familiar with using Excel and its data management features.

Remove Duplicate Data Records from an Excel Database

  1. Open an existing Excel database file

  2. Click on any cell containing data in the database

  3. Click the Data tab on the Ribbon

  4. Click on the Remove Duplicates icon

  5. Clicking on the icon highlights all data in the database and open the Remove Duplicates dialog box

  6. When the dialog box opens, all of the column headings are selected by default

Removing Identical Data Records

To remove only those records from the database that match another record exactly:

  1. Leave all column headings selected

  2. Click OK

  3. If any identical records were found a message will be displayed informing you of the number of duplicate values that were found and removed and the number of unique values that remain

Removing Partially Matching Data Records

To remove records from the database that have duplicate data in one or more columns:

  1. Remove the check marks from those columns you do not want to compare

  2. Click OK

  3. If any partially matching records were found a message will be displayed informing you of the number of duplicate values that were found and removed and the number of unique values that remain
Related Video
Excel Lists- Remove Duplicates

©2014 About.com. All rights reserved.