polarisking
Member
Obvious answer uses the Transitive property we learned early on; you know, if A = B, and B= C then A = C. Could be written as
=AND(Cell01=Cell02, Cell02=Cell03) = True
For N values, though, is there an elegant using a CSE formula, perhaps? or something else?
Thank you, in advance.
=AND(Cell01=Cell02, Cell02=Cell03) = True
For N values, though, is there an elegant using a CSE formula, perhaps? or something else?
Thank you, in advance.