Rotating the team players as needed on player avaliablity

**Juttskt** · 07-08-2019, 07:22 PM

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

**Pepe Le Mokko** · 07-09-2019, 02:20 AM

Hi and welcome
although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
So, please update your profile to something more precise then "Earth" or "07106" ( country will suffice, no need to be more precise).
Thank you for helping us to help you

**Juttskt** · 07-09-2019, 10:20 AM

Good Morning mokko yes i update my information. i did not mean to hide my self. my focus was to ask questions and learn something new

**Juttskt** · 07-10-2019, 11:06 PM

Is anyone sort out so far ?

**JeteMc** · 07-14-2019, 02:36 PM

This proposal makes a change in the set up of the range on Sheet2 so that instead of using AVAILABLE and N/A it lists the names of the players that are available and leaves blanks for the ones that are not.
The array entered formula* used to populate the range on Sheet1 is a modification of one CAntosh developed:

Formula:

Please Login or Register  to view this content.

*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.