Hey,

I've been trying to make a slightly more fancy way of alerting myself of duplicates of course I can do things like:

=IF(COUNTIF($A$2:$A100, $A2)>1, "Duplicate", "")
However I want to add a cell to the right to show the address of the 1st copy of the duplicate and then another cell to the right of that to show the address of the 2nd duplicate.

Essentially making it look like:

mQYu58C.png

Anyone able to assist me with what functions I should be looking at?