Formula to identify duplicates in Excel

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: