Forum Discussion
Compare two files with saving only the difference
Hi, I have 2 files that are very similar in terms of values, but there is a slight difference between them. I want to get the difference between these two files in the new file. The files are 90% the...
If the comparison being done is strict cell-for-cell book A vs book B, you could enable Inquire (if you're using an Enterprise version aka Excel provided by an employer) and use Compare Files.
https://support.microsoft.com/en-us/office/compare-workbooks-using-spreadsheet-inquire-ebaf3d62-2af5-4cb1-af7d-e958cc5fad42
https://support.microsoft.com/en-us/office/compare-workbooks-using-spreadsheet-inquire-ebaf3d62-2af5-4cb1-af7d-e958cc5fad42