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







Wonderful. Thanks


Another option: