Finding duplicates between two different workbooks

Occasional Contributor

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)




2 Replies

@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.

Screenshot 2022-01-08 at 04.24.11.png

Thanks, I'll give that a try.