Finding the Differences between two sheets

[amit_gupta123]

Hii

I have datasets in sheet one and two. I want to extract the differences which are appearing in sheet 1 but not in sheet 2 and vice versa. These differences get extracted and pasted in third sheet. The base to find the differences is combination of Invoice number and the amount.

Please advice
The sample sheet is attached herewith
Regards

 

[Chihiro]

Very simple using PowerQuery. Just do Left Anti join of respective tables.

See attached sample.

 

[amit_gupta123]

Thanks a lot for the response ...

The challenge is I am using Excel 2007

Regards

 

[Chihiro]

Hmm, in that case you can still use MS Query.

Have a read of article below. For your purpose, you'd be using "The Subtract Join" section.
https://support.microsoft.com/en-ca/kb/136699