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:   Managing Conditional Formatting Rules 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 Rules in Excel

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

Data Tab → Data Tools Group → Remove Duplicate Command icon

Worked Example:   Highlight rows that contain in Excel

Leave a Reply

Your email address will not be published.