Introduction: ​Remove Duplicate Values in Excel for Mac

Picture of ​Remove Duplicate Values in Excel for Mac

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

Picture of Highlight All Data to Be De-duplicated

Step 2: Click the Data Tab

Picture of Click the Data Tab

Step 3: Click the Remove Duplicates Icon

Picture of Click the Remove Duplicates Icon

Step 4: ​In the Remove Duplicates Window:

Picture of ​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

Picture of Back at Your Spreadsheet, You Should Find Your Data With All the Duplicates Removed

Comments

JohannaM1 (author)2015-08-24

Great help. Thanks.

seamster (author)2015-01-30

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.

About This Instructable

24,973views

2favorites

License:

Add instructable to: