Hi,
In my roster I have a table of shifts (2 columns) In order to check that the placment follows the work rules.
for example: if you work saturday morning you cant work sunday afternoon.
I need a formula to check IF cell A1 (shift) AND A2 (next day shift) = same combination(RAW) in the list = True/false
Tried usin IF with MATCH ( if raws numbers from the match equals each other then TRUE) but
the problem is some values (shift name) are repetitive, so no good...
In my roster I have a table of shifts (2 columns) In order to check that the placment follows the work rules.
for example: if you work saturday morning you cant work sunday afternoon.
I need a formula to check IF cell A1 (shift) AND A2 (next day shift) = same combination(RAW) in the list = True/false
Tried usin IF with MATCH ( if raws numbers from the match equals each other then TRUE) but
the problem is some values (shift name) are repetitive, so no good...