Excel 2007: Automatically Remove Duplicates
Contributed by Rob Rogers 
Tagged: Microsoft Excel Removing duplicates from a spreadsheet can be a timely task, fortunately Excel can do this for you. Here’s how…
1. Select the range of data in your spreadsheet.
2. Go to the Ribbon and select the Data tab.
3. In the Data Tools section, click Remove Duplicates.
4. In the Remove Duplicates dialog box, check the column(s) you want searched for duplicates. You should check all columns that need to be a match to be considered a duplicate to prevent the accidental removal of data you wish to keep.
5. Click OK.
A message will tell you how many duplicate values were found and removed and how many unique values remain in your data. If the result is not what you desired, hit Ctrl+Z to undo the removal of the duplicates and try again.
You may also like -
Excel 2007: Show Formulas to Verify Your Equations
Excel: Prevent Conversion of URLs into Hyperlinks
Excel 2007: Eliminate Blank Rows in a Spreadsheet
Excel 2007: Highlight Duplicates
Classic ASP: Generate Excel spreadsheets on the fly
Microsoft Excel 2003: How To Change the Gridlines Color
How to Remove duplicate files from your iTunes media library
Excel 2007: Have Your Data Read Back To You
Ranked Hard said on December 8, 2008
Succinct and thorough guide. Tips Hat.
Vamz said on June 24, 2009
Is there a way to highlight the duplicates before removing them? I guess that is very useful because you do not want to delete them directly as it is risky
HDF said on November 7, 2010
Yes, you can conditionally format the column so that the duplicates appear in another color.
Steps to follow:
1. Select column in table that contains the values you want to check for duplicates
2. On Ribbon, select HOME tab
3. Select Conditional Formatting/Highlight Cell Rules/Duplicate Values
Anonymous said on November 7, 2010
Wow. Nice tip. I love it.
Thanks for helping our users.
Franco Danna said on May 14, 2011
can you remove both duplicates