loading

Sometimes your Excel spreadsheet contains duplicate data. Excel offers a feature that will scan for and remove duplicated values.

Important things to know:

  • When you remove duplicate values, only the values in the range of cells or table are affected.
  • Any other values outside the range of cells or table are not altered or moved.
  • Because you are permanently deleting data, it's a good idea to copy the original range of cells or table to another worksheet or workbook before removing duplicate values.
  • When you remove duplicate values, you permanently delete duplicate values.

Image from: http://www.nedarc.org/tutorials/analyzingData/cleanTheData/determineCurrentDesiredQualityLevels.html

Step 1: Highlight all data to be de-duplicated

Step 2: Click the Data tab

Step 3: Click the Remove Duplicates icon

Step 4: ​In the Remove Duplicates window:

  1. choose the column(s) you wish to remove the duplicates from (example shown: Column E—Period)
  2. at the bottom of the column listing, the number of duplicates found and remaining number of unique values is displayed.
  3. click the Remove Duplicates button

Step 5: Back at your spreadsheet, you should find your data with all the duplicates removed

<p>Great help. Thanks.</p>
<p>Very nice! Excel is such a powerful tool, and it seems like there's an endless amount of features in it. Thanks for sharing this.</p>

About This Instructable

21,549views

2favorites

License:

More by jelzinga:​Remove duplicate values in Excel for Mac 
Add instructable to: