Basketball Substitution Sheet

[Label-makers]

Hi Guys,
Can anyone help???

I am trying to generate a sheet to manage the substitutions in a basketball game where there are 8 Players (5 on the court / 3 Subs). Each substitution is 5 minute blocks so 8 per game
2 Halves / 20 minutes per half so 4x substitutions per half / 8 x subs per game

I need to generate a list of 3 players each block and rotate so that all players sit off for equal time
I also need to change this each week so that different players are off the court at different times from week to week.

i.e.
1st Block
Player 1, 2, 3
2nd block
Player 4,5,6
3rd Block
Player 7,8,1
4th Block
Player 2,3,4
5th Block
Player 5,6,7
6th Block
Player 8,1,2
7th Block
Player 3,4,5
8th Block
Player 6,7,8

Can anyone help?

[JeteMc]

Perhaps that following will help.
Set up a table with columns B:I displaying 'x' to indicate the players that will be off the court that block. Set up a separate table that shows the players names adjacent to a column of random values which can be refreshed by pressing the F9 key.
Column A in the first table is populated using: =INDEX(K$2:K$9,MATCH(AGGREGATE(15,6,L$2:L$9,ROWS(A$1:A1)),L$2:L$9,0))
Let us know if you have any questions.

[Label-makers]

Thank you very much, works perfect!!!

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.