I need to compare 2 large lists of numbers and out put numbers that are in both lists.

Hi everyone thanks for taking the time to help out.

I have two databases in excel I need to compare. One contains the serial numbers of a bunch of items that are assigned to my organization. The other contains the serial numbers of all the items in my organization that are registered for maintenance. Over time these two lists no longer match.

I can easily put all the data in one workbook in two separate columns. What I want to do is run a macro that can compare these to lists and give three outputs which are serial numbers that are:

1) Only in list A.
2) Only in list B.
3) In both lists A and B.

Thanks for the help!

Maybe:

Please Login or Register  to view this content.

Comparing Columns A and B.
Output 1) - Column C
Output 2) - Column D
Output 3) - Column E