Hi,
I'm struggling to create a list of duplicates in Excel. I have a list of dates in column A and names in column B. I'd like to create a list in 2 separate columns, let's say C and D, that lists all the names that are duplicated in column B, along with the date that each person appears.
So if row 3 and 4 had the same name with the dates 10/8/19 and 14/8/19, repsectively, then I would like them to appear in columns C and D like that.
Ideally I would like this to run automatically as new names and dates are continuously added, so I would imagine an array formula would work well but I can't seem to do this myself. I'm also unsure how to input array formulas in Excel on a mac (2019 version), is it command-shift-enter?
Many thanks!