Incorrect result for both types of formulas- all are numbers and not text.
Do you see anything wrong. Ron's results in the wrong answer if the numbers
are moved around ( see bottom example ).
Testing of the formulas by rearranging the numbers proved incorrect on both
formulas.
The oddest is that as you change numbers in the four number set, the result
will remain the same, give you an incorrect result, or change with only one
number being added that is in the entire six set.

It seems to work on the intial test but as you are changing the four set,
things start happening that result in an incorrect result.

(Excelent formula) Gave a 1 when the four set was 4,5,6,7 but remained a 1 when the new set came in as 1,2,7,4

g h i j k l m n o p q

60 1 2 7 4 4 5 6 7 8 2 1

q60 content - {=IF(OR(G60=K60:P60,H60=K60:P60),1,0)}

(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.

g h i j k l m n o p q

59 1 2 4 7 7 4 2 1 8 2 FALSE

q59 content - {=AND(OR(G59=K59:N59),OR(H59=K59:N59),OR(I59=K59:N 59),OR(J59=K59:N59))}






"excelent" wrote:


xxxx-xxxx
{=IF(OR(G59=K59:N59,H59=K59:N59),1,0)}
{=IF(OR(--G59=--K59:N59,--H59=--K59:N59),1,0)} * use this if any textvalues

xxxx-xxxxxx
{=IF(OR(G59=K59:P59,H59=K59:P59),1,0)}
{=IF(OR(--G59=--K59:P59,--H59=--K59:P59),1,0)} * use this if any textvalues



"Shu of AZ" skrev:

Thanks for the quick response but Im not getting the correct result

{=AND(OR(G59=K59:N59),OR(H59=K59:N59),1,0)}

The value still comes up false yet the result should prove true. G59 is the
first cell.

7431 478641 FALSE

I was given six numbers and then was given 4. I need to represent a 1 if
both of the first two numbers in the four number group ( 7 and 4 ) are found
in the first four numbers ( 4,7,8,6 ) of the six number group ( 478641).

Thanks again!