How to Remove Duplicate Records in Excel Based Upon Multiple Criteria

Data in spreadsheets such as Excel can have duplicate values on one, several or all columns. In Excel, you can easily remove duplicates based on duplication in any set of columns.

Instructions

1. Decide on the columns you wish to include in the removal. For example, if you have data on name, age, height, weight and telephone number, you might want to include only the last three in your search, since names are prone to misspelling.

2. Highlight the data from which you wish to remove duplicates.

3. Click on "data."

4. Click on "remove duplicate."

5. Check the boxes next to the names of those columns to select the columns you wish to include.

6. Click "OK."

References

• Addictive Tips