On Sun, 15 Oct 2006 08:56:02 -0700, Shu of AZ
wrote:

(Ron's formula) Gave a TRUE at first with 7,4,2,1 but as the numbers came in rearranged in the four set, it went to false although the numbers do exist. This is for 4 of 6.

This explanation of how you changed the input is completely incomprehensible to
me.

What set of numbers, that you think should give a TRUE, is giving a FALSE.

The set you posted gives a TRUE

G59 H59 I59 J59 K59 L59 M59 N59
1 2 4 7 7 4 2 1


=AND(OR(G59=K59:N59),OR(H59=K59:N59),OR(I59=K59:N5 9),OR(J59=K59:N59))

And, as I wrote previously, if you want the formula to return a 1 or 0, merely
precede the above with a double-unary:

=--AND(OR(G59=K59:N59),OR(H59=K59:N59),OR(I59=K59:N59 ),OR(J59=K59:N59))


--ron