Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can excel have a button to input (stamp) the systems date and/or . | Excel Worksheet Functions | |||
Combining data from two columns | Excel Discussion (Misc queries) | |||
VBA to concatenate Text and/or Numbers and/or dates etc | Excel Discussion (Misc queries) | |||
Combining AND/OR in an IF statement | Excel Worksheet Functions |