Help with referencing rows/cells

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

Please read the yellow banner at the top of the page. Don't forget to include a mock-up of what the answers should be.