6 players each play each other in 6 lanes, but never same lane twice

[Terri12]

Im not sure this is possible? its been causing me headaches .
I have 6 players and 6 lanes. they must play each other but cannot play on the same lane twice. I wondered if there was some code or simple formula .

• Each player must play each other but must not play on the same lane twice

many thanks for anyone who can help.
terri

 

[Luke M]

Hi Terri, and welcome to the forum!

With the requirements/restrictions on where you can play, I don't think you can make it "random" selection. (Philosophical debate, even an ordered list is one probable outcome of a random toss, so does it still count?)

Also, current setup is impossible to solve. Take team A. To play all other other teams (rule #1), that would be 7 games. But, there's only 6 lanes, so they'll have to use one lane more than once, but that violates rule #2.

 

[Terri12]

Luke thanks so much..its got my simple brain thinking.

• I could use some code to randomly select the players first
• secondly the maximum players would be 6 players. Would you know of any formula that can alllocate 6 players to player but not on the same lane twice. kind regards Terri

 

[NARAYANK991]

Hi ,

Luke is going by what he sees in your workbook ; I will go by what I see in your post.

Your workbook shows there are 8 players , which is why Luke has mentioned that 7 games will be required if player A has to play all the other players.

If there are only 6 players , then player A needs to play only 5 other players ; this can certainly be done when there are 6 lanes available.

In fact only 5 lanes will be used.

Narayan

 

[Terri12]

Hi ,

Luke is going by what he sees in your workbook ; I will go by what I see in your post.

Your workbook shows there are 8 players , which is why Luke has mentioned that 7 games will be required if player A has to play all the other players.

If there are only 6 players , then player A needs to play only 5 other players ; this can certainly be done when there are 6 lanes available.

In fact only 5 lanes will be used.

Narayan

Thanks Narayan - My apologies I initially had 8 players but changed it to 6. I see what you've done on the sheet and its exactly what I want for 1 Match, however we have several matches, also the list in the Column A may not come in alphabetically order. For example the order of letters could be - "G D C F B A" or "D A B F C E" I was hoping there was a code or a formula that would automatically allocate the players in the appropriate cell. The way you have done is correct, however, A will always play B in lane 1 in every scenario? I need it be automated where different players to play in different lanes but still stick to the only play in one lane once and must play everyone.
Hope this makes sense . Many many thanks
Terri