Find the differences between 2 Excel worksheets

Question

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 sets is not in the 800 sets. Can I find this out using Excel?

Answer 1

Place your column in column A of each spreadsheet, with one value per row. Type in column B of the bigger sheet.

=VLOOKUP(A1,'[Book2.xlsb]SheetName'!$A:$A,1,FALSE)

Then, duplicate the formula as far as your data column will allow.

If the formula returns FALSE, the corresponding data is not present in the other worksheet.