562 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 one 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).
Following a question from a course, I thought I'd give 3 possible ways in which you can find all the differences between two worksheets. The example I'll use is to see if someone's been tampering with my shopping list. Here's the original:
The original shopping list.
And here's the second list:
The revised shopping list (in each case I've helpfully coloured in the cells which are different).
If you want to try any of the methods given in this blog, you can download the two worksheets to compare here. The three methods are:
I've used Excel 2016 for this blog, and included notes when you'll need to do different things for different versions.
So ... let's start with a vanilla Excel method, combining various functions.
|Parts of this blog|
Some other pages relevant to the above blogs include:
25 Aytoun Street