You want to compare data between 2 columns, row-wise.
There is a very simple way to do it.
There is a very simple way to do it.
- Select both columns with data
- Press F5 and select special (alternatively, from home ribbon, click on Find & Select and then choose Goto Special)
- Now, click on row differences and press OK.
- Excel instantly highlights all the cells in 2nd column that do not match with first column.
- You can simply then change the colour of the font, or apply a fill to the cells, to draw your attention.
You may sometimes also want to highlight all the blank rows in your data, and then delete them in 1 shot.