Jan 07 2022 03:58 PM
I am looking for the best and simplest way to identify duplicates between two worksheets in different workbooks.
The data structure between the two worksheets is the same. My preference would be to identify the lines and create a list, OR, delete the "duplicate" from one of the worksheets, then I can merge the two worksheets into one document.
I'm using Excel for Mac Version 16.57 (21120501)
Thanks
EJ
Jan 07 2022 07:30 PM
@ECJ53 The simplest would be to copy/paste data from both sheets into one. Then select the entire range with data and select Remove Duplicates on the Data ribbon (Data Tools group), and follow the instructions.
Jan 10 2022 02:50 PM