Use the formula =A2<>B2 in an adjacent column — it will show TRUE where the rows do not match. Double-click the corner of the cell to apply it to the entire list.

To visually highlight discrepancies, apply conditional formatting with the rule =$A2<>$B2.

If the row order is different, the COUNTIF function will help. The formula =COUNTIF($B:$B;A2)=0 will find values from the first column that are not in the second.

For complex data and a clear report, use the detailed guide on comparing columns in Excel.

🔗 Source: excel.rf