like 80 people on two shifts and 40 on the third. i want to move small shift to day and slide half of day into swing and half of swing into graveyard. any suggestions? thanks in advance.
First rotation: pick the first 40 people (by alphabetic order) from the
larger groups to rotate to the next shift.
Each subsequent rotation: move the group of 40 that did not move the
last time.
--
Regards,
Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
