I would appreciate your help in the following issue: 3 columns with dates, 6 columns with names. Any name can be in any column J-O, any date can be in any column G-i. Even on different rows.
One name cannot be assigned a date >= 2 times (the guy can't be auditing in 2 places at the same time).
When this happens, I need highlighted the duplicate date and name.
I have included 2 images ("Registru", where I need to input the VBA code and "Registru2", where I exemplified finding the duplicates using 18 additional columns concatenating date + name).
Thank you very much,
Img2.jpg
Img3.jpg
Bookmarks