Hi experts,
Kindly assist, I'm trying to plan roster for my team, they can only work a maximum of 8 consecutive days.
So the work days cells, I will key as "1" and "off" will be off days. So I want validation to prevent me from keying "1" after 8 consecutive consecutive "1".
Or in more details is it possible to detect 8 consecutive different text "position" from a list of table which lists labelled?
Kindly assist, I'm trying to plan roster for my team, they can only work a maximum of 8 consecutive days.
So the work days cells, I will key as "1" and "off" will be off days. So I want validation to prevent me from keying "1" after 8 consecutive consecutive "1".
Or in more details is it possible to detect 8 consecutive different text "position" from a list of table which lists labelled?