You can compare your Excel data a bunch of different ways. For example, conditional formatting is one great way automate that comparison. This week I’d like to share something that works really well for quick, one-time comparisons.
How It Works
- Select the columns of data you want to compare.
- Press the F5 key to open the Go To box.
- Select the Row differences option, then click OK
Excel should have highlighted all the values in the other column(s) that don’t match the corresponding data in the first column.
NOTE: This will work with multiple columns and it does matter HOW you select your range. For example, in the 1st example below I selected the cells by starting in A1. Now compare that to the 2nd example where I started in C8.
The comparison is from the first column selected to all the other columns.