Finding duplicates between two different workbooks

Question

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

riny_van_eekelen · Answer

ECJ53&nbsp;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.

ecj53 · Answer

Thanks, I'll give that a try.

Forum Discussion

Finding duplicates between two different workbooks

2 Replies

Resources