how to find out if same column value matches same column in excel code example
Example: check if values in two columns are equal excel
=IF(COUNTIF($B:$B, $A2)=0, "No match in B", "")
=IF(COUNTIF($B:$B, $A2)=0, "No match in B", "")