Hi Duke, Thank you for getting back to me so quickly. I tried your array
formula, and it worked for the first scenario where the cells were worked in
order, but not for the second scenario where I worked L2, L3, started to work
L3 and stopped and then went on to work L4 and part of L5. It should have
returned a false according to your logic. It did return a TRUE for the first
scenario. I did do the contr shift enter. I tried it a couple of ways. I'm
using 2003 excel, does that make a difference?



"Duke Carey" wrote:

This is an array formula that you need to enter by pressing Ctrl-Shift-Enter

=MAX(--(L2:L6="y")*ROW(L2:L6))<MAX(--(L2:L6="n")*ROW(L2:L6))

It will return FALSE if you are out of order and TRUE if you are IN order

"Wendy" wrote:

I have a spread sheet in which cells L2:L6 must be worked in order, and in
cell L7 I want to put a Yes or No if those cells were worked in order. a Y
or an N means I have completed the work for those cells. For ex, if its goes
in this order -
L2 = y, and L3= y, and L4,5,6 are all N, then I should have a YES in L9
because I started with L2 and worked my way down.If I did this,

L2= y, L3= y, L4 = n, L5 =y, and L6 = n, than it shows that I worked my
cells out of order and they should have a big fat NO in box L9. Here is the
IF/OR statement I wrote, but its not working.

=IF((OR(L2="Y",L3="N",L4="N",L5="N",L6="N"),"YES", "NO"),IF(OR(L2="Y",L3="Y",L4="N",L5="N",L6="N"),"Y ES","NO"),IF(OR(L2="Y",L3="Y",L4="Y",L5="N",L6="N" ),"YES","NO"),IF(OR(L2="Y",L3="Y",L4="Y",L5="Y",L6 ="N"),"YES","NO"))

I'm very new with excel, and not sure about where to put comma's, etc. or if
this would even be an IF statement function as opposed to a LOOKUP. Any help
would be very much appreciated. Thanks!

Wendy