Sir,
Thanks for your prompt response and valuable information,
I have updated formula as per your instruction (file is attached for ref.), however, result is not appearing as desired..
requirement
- We have to allocate all the staff in following manner in rotation (whenever staff deployed in D and N);
ODC Gate
Lane_01
Lane_02
Lane_03
Lane_04
Lane_05
Lane_06
Lane_07
Lane_09
Lane_10
Lane_11
Lane_12
South Gate
Yard Gate_01
Yard Gate_02
Reliver_01
Reliver_02
Reliver_03
Reliver_04
Reliver_05
and
Pre-Gate (fixed POW for 1201 Pramod Rohidas Patil & 1212 Mangesh Govardhan Gharat )
Thanks in advance
- Ravi
Bookmarks