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:
- choose the column(s) you wish to remove the duplicates from (example shown: Column E—Period)
- at the bottom of the column listing, the number of duplicates found and remaining number of unique values is displayed.
- click the Remove Duplicates button