Identifying Duplicates in Excel- Conditional Formatting

Please sign up for the course before starting the lesson.

Duplicate entries in Excel are often the cause of problems. There are a number of ways to identify which items are duplicates. One of the easiest ways is to use the Conditional Formatting tool which will highlight either all the duplicates or all the unique items. A major benefit is that this is live in that as new data is entered it will automatically change colour if it is a duplicate.

Back to: Data cleanup in Excel > Identify and Remove duplicates in Excel