formula to give you a comparison:

=AND(A2:A11=B2:B11)

Enter the formula by pressing Ctrl+Shift+Enter. If done correctly it will appear as the following:

{=AND(A2:A11=B2:B11)}

For a case-sensitive comparison, the equals operator will not work. Instead, the EXACT() function should be used.

{=AND(EXACT(A2:A11,B2:B11))}

Comments are closed.