how to compare 2 number columns for equals in excel code example Example: check if values in two columns are equal excel =IF(COUNTIF($B:$B, $A2)=0, "No match in B", "")