View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shu of AZ Shu of AZ is offline
external usenet poster
 
Posts: 130
Default 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!