HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: Automatically Remove Duplicates

Excel 2007: Automatically Remove Duplicates

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.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

error: Content is protected !!