Trying to find inconsistencies between two sets of data (2 columns)

at least i think it is.

so we have two sets of data, each one is one column worth, probably hundreds in each column. they are both in two separate spreadsheets for now. what i want to do is check column 1 against column 2 and determine which items are included in both columns.

what is the easiest way to do this? basically, all of column 1 has been scanned in and all of column 2 is confirmed delivered. if there are any that appear on column 1 but not on column 2, we want to know about them.

i thought about adding a character to every entry in column 1, then merging the two into one column, sorting them and seeing if there were any entries that appeared twice, one with the extra character to indicate which column it originally came from and the other not.

any ideas? thanks

that should work but i don't have the data in hand yet. i'll give it another look and report back. cheers!