How to find compare text or find out different between 2 files?

[dangthuylinh27]

Hi everyone,
I have two excel files, and I need to compare the content to find out what’s different between them. What’s the best way to do this? I’m open to using any tool. Any recommendations for reliable and easy-to-use solutions would be appreciated!

Thanks in advance!

 

[Alex Blakenburg]

Are you using an Enterprise version of MS365 ?
If you are, you should have access to the Add-In Inquire, you just need to activate it. It can do workbook comparisons.

Turn on the Inquire add-in - Microsoft Support

To use the Spreadsheet Inquire tools, you need to turn on the Inquire add-in for Excel.

support.microsoft.com