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((A2=D2),”same”,”DIFFERENT”)

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