Have you ever had two similar looking spreadsheets in Excel and wanted to find out which rows contain differences? If your lists are small, you could try to view the two spreadsheets either side by side horizontally or vertically. Click Excel’s View tab then click New Window. Then click Arrange All with vertical.
With vertical this is what you get.
However, when your lists contain too many rows to compare in Excel, then you can export the data to Access. Either run the Excel import Wizard from Access or copy and paste between the programs.
Select the “Find Unmatched Query Wizard” from the Query Wizard button from the Insert Tab in Access.
Click Finish and view the dataset. You may need to run the unmatched query wizard again a with changing the table comparison direction if the first query did not produce the results you thought.