How to COMPARE 2 COLUMNS in Google Sheets

In Google Sheets, you can compare the contents of two columns using a simple formula.

Here's how to do it.

Set out your two columns and then in the third column, create a formula:
To compare cell A2 and B2, in cell C2 create the formula:
=A2=B2

Compare columns in sheets
Spreadsheet compare columns
Difference between two columns

Find the difference in google sheets
#spreadsheet #googlesheets

In Google Sheets, you may want to find the difference between two columns. It's very easy to do, even if you don't know formulas.

This video is about:
compare values
compare columns
find the difference
data difference
different values
compare columns in google sheets
spreadsheet compare

[canyol]

Thank you for your video! Is there any way to compare more than 2 columns? I have 4 columns in which numbers should match. If all four numbers are equal, it's true otherwise (if at least 1 out of 4 do not match) is false. Ideally to make it with conditional formatting to color in green if true and in red if false.