Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
I have been racking my brains for the last three days trying to work a logical sequence to setting up fixtures for a 19 week league competition for 20 players. Here's what I want to do: 20 players (numbered 1 thru 20 for ease of use) each play a game per week, so there's 10 games per week. Each player only plays an opponent once every 19 weeks. Each player obviously plays 19 games - one player plays 19 opponents. I just can't work out a formula to set the fixtures automatically without any duplications. Can anyone help or point me in the right direction? cheers in anticipation DubboPete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fixtures table | New Users to Excel | |||
How do I set up 16 team fixtures each Sunday | Excel Worksheet Functions | |||
league table | Excel Discussion (Misc queries) | |||
Racing League needs help | Excel Discussion (Misc queries) | |||
I AM TRYING TO PLAN A FIXTURES TABLE INVOLVING 12 TEAMS | Charts and Charting in Excel |