compare two excel containing multiple sheets and ~50 columns

[mohd_shakeel]

I have two excel both files are similar, both have same count of sheets and columns on each sheets. 

Three tabs and more than 50 columns in each tab.

columns contains 'Any value' (text/decimal)

there might be chances that few of the cells/fields may vary in one file. 

I am not able to find a way how to compare both the files and find out the deviation/difference(s) between two file.

[drew9]

Hi @mohd_shakeel ,

I actually built an analytic app for this exact purpose. See attached. If your files have a primary key, I'd recommend using that as long as there are not duplicate keys. Record position will work as well but this is assuming that the order of the rows has stayed consistent. Hope this helps!