Identify Duplicate Values vs Remove Duplicates in Excel

by

There’s a difference between identifying duplicated values/records and removing duplicated values/records in excel worksheet.

Worked Example:   Shade Alternate Rows in Excel

To identify duplicate values/records in excel; Use conditional formatting.

Home Tab → Styles Group → conditional formatting→Highlight Cell rule →Duplicate Values

Worked Example:   Conditional Formatting Icon Sets Examples in Excel

To remove duplicate values/records in excel; Use remove duplicate

Data Tab → Data Tools Group → Remove Duplicate Command icon

Worked Example:   Highlight unique values in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *