hi guys,
i need a little help
i have total 14 player and only 4 players can be active for one day
i am working on rotating order which i have done successfully but i am stuck in an issue which is players are not available for entire week.
so it requires to schedule players on their availability days. also player should have equal days to play in a week and if any player left over should continue rotating for next week.
please any one can help me
my workbook sheet1 is my rotating orders sheet.
sheet 2 shows their availability.
anyone can help
thank you rotating Example .xlsx
Bookmarks