Posted By: Anonymous
I have two excel files with the same structure: they both have 1 column with data. One has 800 records and the other has 805 records, but I am not sure which of the 5 in the 805 set are not in the 800 set. Can I find this out using Excel?
vlookup is your friend!
Position your column, one value per row, in column A of each spreadsheet.
in column B of the larger sheet, type
Then copy the formula down as far as your column of data runs.
Where the result of the formula is FALSE, that data is not in the other worksheet.