Hi all - I need to be able to identify which cells have duplicate information in them and in the cell next to them have the cell(s) that are duplicates of that. I've found how to see how many duplicates there are of the cells but is there a formula that I can make to output the duplicate cells?

Thank you all