​Remove Duplicate Values in Excel for Mac




Introduction: ​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

Teacher Notes

Teachers! Did you use this instructable in your classroom?
Add a Teacher Note to share how you incorporated it into your lesson.

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

Be the First to Share


    • Raspberry Pi Contest 2020

      Raspberry Pi Contest 2020
    • Wearables Contest

      Wearables Contest
    • Fix It Contest

      Fix It Contest

    2 Discussions


    5 years ago on Introduction

    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.