Comparing Two Ranges (advanced)

compare list.xlsx

Hello All!

So I am struggling with a problem. The issue involves comparing two ranges. I have to sort through a large list for duplicates and differences. The ranges are text based such as GM7, T6S, GE-68..etc. My dream is to take duplicates of data from a open workbook and compare it to a given range in a separate file, and print them out on another worksheet. This may involve running a program?

Ideally there would be a file that contains a range of data (A). The duplicates of list (B) to be compared to the data (A) that is in a different file. The duplicates of (B) to be printed on another sheet. The non-duplicating data will also be sent to another sheet. (If the contents cannot be sent to a different sheet, another column would be Ok, but not ideal).

What I have now....
List A needs to be compared to List B. I have found a way to print the duplicates. This is how I did it...

=IF(ISERROR(MATCH(A1,$B:$B,0)),"",A1) ------------ This would ultimately print out the duplicate, if there was no duplicate, then nothing is printed in column C.

What I want....
List A is in a separate file. I have List B. I run a compare function. The function/program prints out duplicates in another sheet or column (if necessary). The function /program prints out the differences in another sheet or column.

Thanks, I hope you can understand the question! - I attached my compare file

Thank you for your input!

Now is there a way to have List B as a separate file that I can open up and compare List A to that data base?