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.