Match The Two Columns Row-By-Row With Comparison Operators If you need to compare two columns in Excel row-by-row instead of the entire column at once, use comparison operators.

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.