Hi all,
I've been fiddling around all afternoon trying to figure this out, and ended up here after the frustration set in.
Problem: I have two variable, that I need rotated, Shifts vs Staff so there's an even distribution of duties.
excel.jpg
I need the 5 staff codes to rotate all around the shifts and other staff. I'm pretty sure there's 120 different combinations which will be good for 2+ years.
i'm hoping for a easy formula to create that table
Thanks for your help
Bookmarks