Formulas – Comparing two columns

When you have 2 columns and would like to compare the values in each, it is easiest to use a furmula.

Simply use the ‘IF’ function and provide the 2 cells in each column, then copy the formula down the page.  As an example, to check if A2 and D2 are the same, add this formula to cell E2.


If the values in A2 and D2 are the same, you will see “same” in E2, otherwise you will see “DIFFERENT” in E2.  Using capitals and a different word will make it easier to see.

As an advanced tip, to change colours of the ‘DIFFERENT’ cell, use the Conditional Formatting!!

Leave a Reply