True False problem

Copper Contributor

How do I have Excel compare the data in a row of cells to that in another row of cells and return a "true" if they all match and "false" if one or more does not match.  Example:  Compare b1 through k1 to b2 through k2 and reply "true" if all cells match and "false" if any do not.

3 Replies

Hi,

 

=PRODUCT((B1:B40=K1:K40)*1)

0=False

1=True

@Tom_Shuler 

Wonderful. Thanks

@Tom_Shuler 

Another option:

=AND(B1:K1=B2:K2)