A coder never fails to miss the unique requirements of the project
owner.

We have shown you how to check column B (2).
You are free to modify the code to include other columns A(1), C
(3)... or build a loop to do that.
Alternatively, if that is your intention, join columns A, B, C...
with =A1 & B1 & C1... in a helper column before comparing.