Hi,

I have a table of shifts (2 columns) In order to check that you work by the work rules.
for example: if you work saturday morning you cant work sunday afternoon.


list 01______________________ list 02
saturday morning____________ sunday afternoon
friday afternoon...____________ saturday evning....

(the list containig the wrong combinations)


I need to check IF cell A1 (shift) AND A2 (next day shift) = same combination(RAW) in the list = TRUE.

Tried usin IF with MATCH ( if raws numbers from the match equals each other then TRUE) but

the problem is some values (shift name) repetitive so no ggod :-(


HELP!!!