Comparing results of two excel spreadsheets

[QATest]

Hi. I have two spreadsheets with results from som tests that I run. I
The first spreadsheet may have extra rows that are not in the second sheet. The second sheet may have rows that aren’t in the first sheet. I would like to capture both these scenarios as well as capture differences in the results and output the list. I have tried the inquiry add on but that doesn’t capture my scenarios above. I have also tried some comparison tools online but with similar results. I was thinking of using lookup.

i am attaching a sample of the two sheets I want to compare

 

[rjtaylor]

The code in my post "Help speed up code loop " might be helpful if the data set is not to large as in mine
https://www.mrexcel.com/forum/excel-questions/1030118-help-speed-up-code-loop.html

 

[QATest]

Unfortunately my spreadsheets are rather large (approx. 20000 records) per sheet.