Find Duplicate & List Addresses

Hey,

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

Please Login or Register  to view this content.

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?

Hey

That works perfectly, I'm trying to figure out the aggregate command as I've never used that. Are you able to separate it into two formulas? I can't figure out the aggregate product/small function