I have two spreadsheets (or tabs in a spreadsheet rather). One of them is a newer version that comes periodically. There is a column in both that has a unique identifier (though there are often duplicates in the new one). I need to figure out a way to have a formula compare the two columns in the old and new spreadsheets, and then any that are on both reports ignore make a list on a seperate tab, then any that are only on the new list to make a list on the seperate tab (copying the entire row would be prefferable though not necessary).
I was thinking of doing a vlookup of a vlookup of a vlookup or something to get this, but I am not sure that would work, of if there is a better way.
Thanks!
Bookmarks