Ron and/or Excelent replies on combining and/or
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!
|