Hello guys,
Having problem for solving formula problem for AF row with - OK
If "TAK" appears in one number order - mark everything in this order as "OK"
If "NIE" appears in whole number order - mark everything in this order as "-"
For now I came with =IF(OR(AND(W1+1=W2;AF2="OK");(S1="TAK"));"OK";"-") but this doesn't mark as OK numbers below in the same order.
I have something like this:
(S) (W) (AF)
NIE 1 OK
NIE 2 OK
TAK 3 OK
NIE 4 -
NIE 5 -
NIE 1 -
NIE 2 -
TAK 1 OK
NIE 2 -
NIE 1 OK
TAK 2 OK
NIE 1 -
TAK 1 OK
I need something like this:
(S) (W) (AF)
NIE 1 OK
NIE 2 OK
TAK 3 OK
NIE 4 OK
NIE 5 OK
NIE 1 -
NIE 2 -
TAK 1 OK
NIE 2 OK
NIE 1 OK
TAK 2 OK
NIE 1 -
TAK 1 OK
Can anyone help me with this case?
Thank you!
Bookmarks