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.
Identifying Duplicates in Excel- Conditional Formatting
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.