Forum Discussion
Workbook Comparison
I need help, as I have exhausted all the options I know. Workbook A is from Oct. Workbook B is from Nov. Each workbook is data exported from our EHR system, and I could not choose how it was...
If you're using an enterprise version of M365 (through an employer), you may have access to Inquire's Compare Files:
More details:
Compare workbooks using Spreadsheet Inquire - Microsoft Support
I tried this and it doesn't give the desired results. I need to know what Data is MISSING from Workbook B that is on Workbook A. When I look at the options they don't answer that for me. Entered Values is only telling me data that was changed. Calculated values is only the values calculated from formulas I put in. Then there is structural etc. None of it returns what I need.