Formula to identify duplicates in Excel

Please sign up for the course before starting the lesson.

Although the tools are useful, it is sometimes necessary to use a formula to identify which items are duplicates without necessarily deleting them. This is easily achieved with the COUNTIF formula. Furthermore, you can use the COUNTIF formula to determine which instance of the duplicate you are looking at (1st instance, 2nd instance etc)

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