which better method to compare two columns no paired code example

Example 1: check if values in two columns are equal excel

=IF(COUNTIF($B:$B, $A2)=0, "No match in B", "")

Example 2: excel vba How to compare two entire rows in a sheet

MsgBox [and(1:1=2:2)]