564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Three different ways to find the differences between two Excel worksheets
Part four of a four-part series of blogs
There are a few ways to find the differences between two Excel worksheets. This blog considers 3 methods (using Excel formulae, using Query Editor and using the Inquire add-in).
For this method you'll either have to load the Inquire add-in within Excel, or run the standalone program called Spreadsheet Compare.
If you're using the Inquire add-in, you will need the Office 365 or ProPlus edition of Excel (see here for more details).
You can start this standalone program in the usual way:
This is a method for finding the program in Windows 10 - it should be installed automatically with Microsoft Office.
To enable the Inquire add-in, first choose File:
Click on the File menu option.
Now choose to show the Excel Options:
Choose this menu option.
Go to your add-ins:
Choose this tab in the left-hand menu.
Choose to show your COM add-ins (whatever these may be!):
Choose the option shown, then click on the Go button.
Tick the Inquire add-in and choose OK:
Your list of add-ins may be different.
You should now be able to choose the Inquire tab on your Excel ribbon:
Choose this option to use the add-in.
Whether using the Inquire add-in or Spreadsheet Compare, first open the two worksheets that you want to compare (note that if you've downloaded the example workbook for this blog, you'll have to move one of the two worksheets into a separate file to try this out).
Choose to compare the two worksheets (the button shown below is for Inquire, but it's similar for Spreadsheet Compare):
Choose this option on the Inquire tab of the ribbon.
Choose the files that you want to compare:
Choose the files to compare, and click on Compare.
The add-in will show your changes, in whatever detail you want!
You can choose which sort of changes you want to see, create histograms of the number of differences found ... and much more!
This is truly the Rolls-Royce of spreadsheet comparison techniques!
|Parts of this blog|
Some other pages relevant to the above blogs include:
25 Aytoun Street