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)
Formula to identify duplicates in Excel
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.