Fixture table help required

bowlerden300

New Member
Joined
Dec 25, 2016
Messages
12
Hi i am relatively new to excel so hope that i am not making a huge mess of this.

i have created a table of 20 rows and 19 columns the rows are of bowlers names and a number suffix ie: rob1 and the columns are headed with weeks 1 -19. I wish to fill the table with fixtures where each player plays each other once. so i wondered if i could use some sort of formula to add the player numbers to the table randomly so they appear only once on each row and column remembering a player cant play himself so player 1 row would not feature a number 1 etc. I have tried to do it manually but it takes so long and i always end up with a number duplicated at some point so an automatic way would be a great benefit any help will be gratefully accepted.
Thank you
Den
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

bowlerden300

New Member
Joined
Dec 25, 2016
Messages
12
Thanks Max i've been and looked but its not what i need i guess i will have to keep struggling to work it out for now.
 

bowlerden300

New Member
Joined
Dec 25, 2016
Messages
12
Match Play League
Week 1Week 2Week3Week 4Week 5Week 6Week 7Week 8Week 9Week 10Week 11Week 12Week 13Week 14Week 15Week 16Week 17Week 18Week 19
Player 1104161217981920153115187146132
Player 2161217981920153115187146134101
Player 3411518714613210116121798192015
Player 4311116512181779148619132021510
Player 5201531141871461321011612179819
Player 6179819201531151871441321011612
Player 7819201531151841461321011612179
Player 8714613210116121794192015311518
Player 9146132101161217481920153115187
Player 1011612179819201531151871461324
Player 1115345187146132101161217981920
Player 1213210116417981920153115187146
Player 1312179819201531151871464210116
Player 1498192015311518746132101161217
Player 1511518714613210116121798192043
Player 1621014121798192015311518714613
Player 1761321011612498192015311518714
Player 1819201531154714613210116121798
Player 1918714613210116121798420153115
Player 2051871461321011612179819415311

<colgroup><col><col span="19"></colgroup><tbody>
</tbody>
 

bowlerden300

New Member
Joined
Dec 25, 2016
Messages
12

ADVERTISEMENT

Above is the table i did manually it took hours of entering all the detail and amending the errors so i wish to be able to replicate this table using some form of automation to save time and eliminate the errors.
Thanks
Den
 

wideboydixon

Well-known Member
Joined
Jun 2, 2016
Messages
3,401

ADVERTISEMENT

See here:

https://en.wikipedia.org/wiki/Round-robin_tournament#Scheduling_algorithm

A simple implementation of this:

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Week 1</td><td style=";">P 1</td><td style=";">P 2</td><td style=";">P 3</td><td style=";">P 4</td><td style=";">P 5</td><td style=";">P 6</td><td style=";">P 7</td><td style=";">P 8</td><td style=";">P 9</td><td style=";">P 10</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";"></td><td style=";">P 20</td><td style=";">P 19</td><td style=";">P 18</td><td style=";">P 17</td><td style=";">P 16</td><td style=";">P 15</td><td style=";">P 14</td><td style=";">P 13</td><td style=";">P 12</td><td style=";">P 11</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Week 2</td><td style=";">P 1</td><td style=";">P 20</td><td style=";">P 2</td><td style=";">P 3</td><td style=";">P 4</td><td style=";">P 5</td><td style=";">P 6</td><td style=";">P 7</td><td style=";">P 8</td><td style=";">P 9</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";"></td><td style=";">P 19</td><td style=";">P 18</td><td style=";">P 17</td><td style=";">P 16</td><td style=";">P 15</td><td style=";">P 14</td><td style=";">P 13</td><td style=";">P 12</td><td style=";">P 11</td><td style=";">P 10</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Week 3</td><td style=";">P 1</td><td style=";">P 19</td><td style=";">P 20</td><td style=";">P 2</td><td style=";">P 3</td><td style=";">P 4</td><td style=";">P 5</td><td style=";">P 6</td><td style=";">P 7</td><td style=";">P 8</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";"></td><td style=";">P 18</td><td style=";">P 17</td><td style=";">P 16</td><td style=";">P 15</td><td style=";">P 14</td><td style=";">P 13</td><td style=";">P 12</td><td style=";">P 11</td><td style=";">P 10</td><td style=";">P 9</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">Week 4</td><td style=";">P 1</td><td style=";">P 18</td><td style=";">P 19</td><td style=";">P 20</td><td style=";">P 2</td><td style=";">P 3</td><td style=";">P 4</td><td style=";">P 5</td><td style=";">P 6</td><td style=";">P 7</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";"></td><td style=";">P 17</td><td style=";">P 16</td><td style=";">P 15</td><td style=";">P 14</td><td style=";">P 13</td><td style=";">P 12</td><td style=";">P 11</td><td style=";">P 10</td><td style=";">P 9</td><td style=";">P 8</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Week 5</td><td style=";">P 1</td><td style=";">P 17</td><td style=";">P 18</td><td style=";">P 19</td><td style=";">P 20</td><td style=";">P 2</td><td style=";">P 3</td><td style=";">P 4</td><td style=";">P 5</td><td style=";">P 6</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";"></td><td style=";">P 16</td><td style=";">P 15</td><td style=";">P 14</td><td style=";">P 13</td><td style=";">P 12</td><td style=";">P 11</td><td style=";">P 10</td><td style=";">P 9</td><td style=";">P 8</td><td style=";">P 7</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style=";">Week 6</td><td style=";">P 1</td><td style=";">P 16</td><td style=";">P 17</td><td style=";">P 18</td><td style=";">P 19</td><td style=";">P 20</td><td style=";">P 2</td><td style=";">P 3</td><td style=";">P 4</td><td style=";">P 5</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style=";"></td><td style=";">P 15</td><td style=";">P 14</td><td style=";">P 13</td><td style=";">P 12</td><td style=";">P 11</td><td style=";">P 10</td><td style=";">P 9</td><td style=";">P 8</td><td style=";">P 7</td><td style=";">P 6</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style=";">Week 7</td><td style=";">P 1</td><td style=";">P 15</td><td style=";">P 16</td><td style=";">P 17</td><td style=";">P 18</td><td style=";">P 19</td><td style=";">P 20</td><td style=";">P 2</td><td style=";">P 3</td><td style=";">P 4</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style=";"></td><td style=";">P 14</td><td style=";">P 13</td><td style=";">P 12</td><td style=";">P 11</td><td style=";">P 10</td><td style=";">P 9</td><td style=";">P 8</td><td style=";">P 7</td><td style=";">P 6</td><td style=";">P 5</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style=";">Week 8</td><td style=";">P 1</td><td style=";">P 14</td><td style=";">P 15</td><td style=";">P 16</td><td style=";">P 17</td><td style=";">P 18</td><td style=";">P 19</td><td style=";">P 20</td><td style=";">P 2</td><td style=";">P 3</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style=";"></td><td style=";">P 13</td><td style=";">P 12</td><td style=";">P 11</td><td style=";">P 10</td><td style=";">P 9</td><td style=";">P 8</td><td style=";">P 7</td><td style=";">P 6</td><td style=";">P 5</td><td style=";">P 4</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style=";">Week 9</td><td style=";">P 1</td><td style=";">P 13</td><td style=";">P 14</td><td style=";">P 15</td><td style=";">P 16</td><td style=";">P 17</td><td style=";">P 18</td><td style=";">P 19</td><td style=";">P 20</td><td style=";">P 2</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style=";"></td><td style=";">P 12</td><td style=";">P 11</td><td style=";">P 10</td><td style=";">P 9</td><td style=";">P 8</td><td style=";">P 7</td><td style=";">P 6</td><td style=";">P 5</td><td style=";">P 4</td><td style=";">P 3</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style=";">Week 10</td><td style=";">P 1</td><td style=";">P 12</td><td style=";">P 13</td><td style=";">P 14</td><td style=";">P 15</td><td style=";">P 16</td><td style=";">P 17</td><td style=";">P 18</td><td style=";">P 19</td><td style=";">P 20</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style=";"></td><td style=";">P 11</td><td style=";">P 10</td><td style=";">P 9</td><td style=";">P 8</td><td style=";">P 7</td><td style=";">P 6</td><td style=";">P 5</td><td style=";">P 4</td><td style=";">P 3</td><td style=";">P 2</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style=";">Week 11</td><td style=";">P 1</td><td style=";">P 11</td><td style=";">P 12</td><td style=";">P 13</td><td style=";">P 14</td><td style=";">P 15</td><td style=";">P 16</td><td style=";">P 17</td><td style=";">P 18</td><td style=";">P 19</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style=";"></td><td style=";">P 10</td><td style=";">P 9</td><td style=";">P 8</td><td style=";">P 7</td><td style=";">P 6</td><td style=";">P 5</td><td style=";">P 4</td><td style=";">P 3</td><td style=";">P 2</td><td style=";">P 20</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style=";">Week 12</td><td style=";">P 1</td><td style=";">P 10</td><td style=";">P 11</td><td style=";">P 12</td><td style=";">P 13</td><td style=";">P 14</td><td style=";">P 15</td><td style=";">P 16</td><td style=";">P 17</td><td style=";">P 18</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style=";"></td><td style=";">P 9</td><td style=";">P 8</td><td style=";">P 7</td><td style=";">P 6</td><td style=";">P 5</td><td style=";">P 4</td><td style=";">P 3</td><td style=";">P 2</td><td style=";">P 20</td><td style=";">P 19</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style=";">Week 13</td><td style=";">P 1</td><td style=";">P 9</td><td style=";">P 10</td><td style=";">P 11</td><td style=";">P 12</td><td style=";">P 13</td><td style=";">P 14</td><td style=";">P 15</td><td style=";">P 16</td><td style=";">P 17</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style=";"></td><td style=";">P 8</td><td style=";">P 7</td><td style=";">P 6</td><td style=";">P 5</td><td style=";">P 4</td><td style=";">P 3</td><td style=";">P 2</td><td style=";">P 20</td><td style=";">P 19</td><td style=";">P 18</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style=";">Week 14</td><td style=";">P 1</td><td style=";">P 8</td><td style=";">P 9</td><td style=";">P 10</td><td style=";">P 11</td><td style=";">P 12</td><td style=";">P 13</td><td style=";">P 14</td><td style=";">P 15</td><td style=";">P 16</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style=";"></td><td style=";">P 7</td><td style=";">P 6</td><td style=";">P 5</td><td style=";">P 4</td><td style=";">P 3</td><td style=";">P 2</td><td style=";">P 20</td><td style=";">P 19</td><td style=";">P 18</td><td style=";">P 17</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style=";">Week 15</td><td style=";">P 1</td><td style=";">P 7</td><td style=";">P 8</td><td style=";">P 9</td><td style=";">P 10</td><td style=";">P 11</td><td style=";">P 12</td><td style=";">P 13</td><td style=";">P 14</td><td style=";">P 15</td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style=";"></td><td style=";">P 6</td><td style=";">P 5</td><td style=";">P 4</td><td style=";">P 3</td><td style=";">P 2</td><td style=";">P 20</td><td style=";">P 19</td><td style=";">P 18</td><td style=";">P 17</td><td style=";">P 16</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style=";">Week 16</td><td style=";">P 1</td><td style=";">P 6</td><td style=";">P 7</td><td style=";">P 8</td><td style=";">P 9</td><td style=";">P 10</td><td style=";">P 11</td><td style=";">P 12</td><td style=";">P 13</td><td style=";">P 14</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style=";"></td><td style=";">P 5</td><td style=";">P 4</td><td style=";">P 3</td><td style=";">P 2</td><td style=";">P 20</td><td style=";">P 19</td><td style=";">P 18</td><td style=";">P 17</td><td style=";">P 16</td><td style=";">P 15</td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style=";">Week 17</td><td style=";">P 1</td><td style=";">P 5</td><td style=";">P 6</td><td style=";">P 7</td><td style=";">P 8</td><td style=";">P 9</td><td style=";">P 10</td><td style=";">P 11</td><td style=";">P 12</td><td style=";">P 13</td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style=";"></td><td style=";">P 4</td><td style=";">P 3</td><td style=";">P 2</td><td style=";">P 20</td><td style=";">P 19</td><td style=";">P 18</td><td style=";">P 17</td><td style=";">P 16</td><td style=";">P 15</td><td style=";">P 14</td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style=";">Week 18</td><td style=";">P 1</td><td style=";">P 4</td><td style=";">P 5</td><td style=";">P 6</td><td style=";">P 7</td><td style=";">P 8</td><td style=";">P 9</td><td style=";">P 10</td><td style=";">P 11</td><td style=";">P 12</td></tr><tr ><td style="color: #161120;text-align: center;">36</td><td style=";"></td><td style=";">P 3</td><td style=";">P 2</td><td style=";">P 20</td><td style=";">P 19</td><td style=";">P 18</td><td style=";">P 17</td><td style=";">P 16</td><td style=";">P 15</td><td style=";">P 14</td><td style=";">P 13</td></tr><tr ><td style="color: #161120;text-align: center;">37</td><td style=";">Week 19</td><td style=";">P 1</td><td style=";">P 3</td><td style=";">P 4</td><td style=";">P 5</td><td style=";">P 6</td><td style=";">P 7</td><td style=";">P 8</td><td style=";">P 9</td><td style=";">P 10</td><td style=";">P 11</td></tr><tr ><td style="color: #161120;text-align: center;">38</td><td style=";"></td><td style=";">P 2</td><td style=";">P 20</td><td style=";">P 19</td><td style=";">P 18</td><td style=";">P 17</td><td style=";">P 16</td><td style=";">P 15</td><td style=";">P 14</td><td style=";">P 13</td><td style=";">P 12</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A1</th><td style="text-align:left">=IF(<font color="Blue">MOD(<font color="Red">ROW(<font color="Green"></font>),2</font>)=1,"Week " & (<font color="Red">ROW(<font color="Green"></font>)+1</font>)/2,""</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B3</th><td style="text-align:left">=$B$1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C3</th><td style="text-align:left">=B2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D3</th><td style="text-align:left">=C1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E3</th><td style="text-align:left">=D1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F3</th><td style="text-align:left">=E1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G3</th><td style="text-align:left">=F1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H3</th><td style="text-align:left">=G1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I3</th><td style="text-align:left">=H1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J3</th><td style="text-align:left">=I1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K3</th><td style="text-align:left">=J1</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B4</th><td style="text-align:left">=C2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C4</th><td style="text-align:left">=D2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D4</th><td style="text-align:left">=E2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E4</th><td style="text-align:left">=F2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">F4</th><td style="text-align:left">=G2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">G4</th><td style="text-align:left">=H2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H4</th><td style="text-align:left">=I2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">I4</th><td style="text-align:left">=J2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">J4</th><td style="text-align:left">=K2</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">K4</th><td style="text-align:left">=K1</td></tr></tbody></table></td></tr></table><br />

Copy A1 down. Copy B3:K4 down as well. B1:K2 would contain your player names.

WBD
 

bowlerden300

New Member
Joined
Dec 25, 2016
Messages
12
See here:

https://en.wikipedia.org/wiki/Round-robin_tournament#Scheduling_algorithm

A simple implementation of this:

ABCDEFGHIJK
1Week 1P 1P 2P 3P 4P 5P 6P 7P 8P 9P 10
2P 20P 19P 18P 17P 16P 15P 14P 13P 12P 11
3Week 2P 1P 20P 2P 3P 4P 5P 6P 7P 8P 9
4P 19P 18P 17P 16P 15P 14P 13P 12P 11P 10
5Week 3P 1P 19P 20P 2P 3P 4P 5P 6P 7P 8
6P 18P 17P 16P 15P 14P 13P 12P 11P 10P 9
7Week 4P 1P 18P 19P 20P 2P 3P 4P 5P 6P 7
8P 17P 16P 15P 14P 13P 12P 11P 10P 9P 8
9Week 5P 1P 17P 18P 19P 20P 2P 3P 4P 5P 6
10P 16P 15P 14P 13P 12P 11P 10P 9P 8P 7
11Week 6P 1P 16P 17P 18P 19P 20P 2P 3P 4P 5
12P 15P 14P 13P 12P 11P 10P 9P 8P 7P 6
13Week 7P 1P 15P 16P 17P 18P 19P 20P 2P 3P 4
14P 14P 13P 12P 11P 10P 9P 8P 7P 6P 5
15Week 8P 1P 14P 15P 16P 17P 18P 19P 20P 2P 3
16P 13P 12P 11P 10P 9P 8P 7P 6P 5P 4
17Week 9P 1P 13P 14P 15P 16P 17P 18P 19P 20P 2
18P 12P 11P 10P 9P 8P 7P 6P 5P 4P 3
19Week 10P 1P 12P 13P 14P 15P 16P 17P 18P 19P 20
20P 11P 10P 9P 8P 7P 6P 5P 4P 3P 2
21Week 11P 1P 11P 12P 13P 14P 15P 16P 17P 18P 19
22P 10P 9P 8P 7P 6P 5P 4P 3P 2P 20
23Week 12P 1P 10P 11P 12P 13P 14P 15P 16P 17P 18
24P 9P 8P 7P 6P 5P 4P 3P 2P 20P 19
25Week 13P 1P 9P 10P 11P 12P 13P 14P 15P 16P 17
26P 8P 7P 6P 5P 4P 3P 2P 20P 19P 18
27Week 14P 1P 8P 9P 10P 11P 12P 13P 14P 15P 16
28P 7P 6P 5P 4P 3P 2P 20P 19P 18P 17
29Week 15P 1P 7P 8P 9P 10P 11P 12P 13P 14P 15
30P 6P 5P 4P 3P 2P 20P 19P 18P 17P 16
31Week 16P 1P 6P 7P 8P 9P 10P 11P 12P 13P 14
32P 5P 4P 3P 2P 20P 19P 18P 17P 16P 15
33Week 17P 1P 5P 6P 7P 8P 9P 10P 11P 12P 13
34P 4P 3P 2P 20P 19P 18P 17P 16P 15P 14
35Week 18P 1P 4P 5P 6P 7P 8P 9P 10P 11P 12
36P 3P 2P 20P 19P 18P 17P 16P 15P 14P 13
37Week 19P 1P 3P 4P 5P 6P 7P 8P 9P 10P 11
38P 2P 20P 19P 18P 17P 16P 15P 14P 13P 12

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1

Worksheet Formulas
CellFormula
A1=IF(MOD(ROW(),2)=1,"Week " & (ROW()+1)/2,"")
B3=$B$1
C3=B2
D3=C1
E3=D1
F3=E1
G3=F1
H3=G1
I3=H1
J3=I1
K3=J1
B4=C2
C4=D2
D4=E2
E4=F2
F4=G2
G4=H2
H4=I2
I4=J2
J4=K2
K4=K1

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>



Copy A1 down. Copy B3:K4 down as well. B1:K2 would contain your player names.

WBD

This looks great just what i am looking for will it be easy to modify for more players as the league is increasing rapidly.
Thank you
 

wideboydixon

Well-known Member
Joined
Jun 2, 2016
Messages
3,401
This looks great just what i am looking for will it be easy to modify for more players as the league is increasing rapidly.
Thank you

Yes if you just follow the pattern of rotating all players except #1. If there's an odd number of players you'll need to add one called "Bye".

WBD
 

bowlerden300

New Member
Joined
Dec 25, 2016
Messages
12
Thank you Wideboy i have used your formulas to create a 22 man matchplay league over 21 weeks and using part of your formula to create lane assignments for each match, i can see this being extremely useful.
Den
 

Watch MrExcel Video

Forum statistics

Threads
1,122,964
Messages
5,599,071
Members
414,281
Latest member
Engjamal2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top