Sometimes, especially when you upload data between environments or companies, it may be hard to check the differences if there is too many data to upload.
It is easy now with to use the functionality "Inquiry" in Excel.
By this functionality, Excel checks two Excel sheets and give you the difference.
For to use this functionality, first you need to activate it.
First you go to File->options->Add-ins
Under manage you select the Comm Add-ins
Then you select the check box for "Inquire" Add-ins.
So you can use it now.
You will see a new tab called "Inquire" in you Excel.
Under the tab, you use Compare files and select two files to compare.
Calculation run and show you the analysis on the analysis form.
*This post is locked for comments