LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Team Draw Roster

You can make the draws using a simple rotation:

1 16
2 1
3 2
4 3
5 4
6 5
7 6
8 7
9 8
10 9
11 10
12 11
13 12
14 13
15 14
16 15

and then:

1 15
2 16
3 1
4 2
5 3
6 4
7 5
8 6
9 7
10 8
11 9
12 10
13 11
14 12
15 13
16 14

--
Gary''s Student - gsnu200839


"Browny" wrote:

i have 16 teams and wish to setup a draw so that each team plays each other
once in round 1 & again in round 2.
Can anyone assist?

--
Browny

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
softball team roster management aa_carrillo[_2_] New Users to Excel 2 March 9th 08 02:07 AM
Team Role Rotation (number of team members is variable) Scott Wagner Excel Worksheet Functions 3 November 17th 06 11:25 PM
How do I make a draw for a 28 team day tournament (bowls)? BOWLS TOURNAMENT Excel Discussion (Misc queries) 1 October 28th 06 05:35 AM
Roster T-ball Coach Excel Worksheet Functions 0 May 31st 06 05:41 AM
Roster Greg Brow New Users to Excel 9 February 10th 05 04:52 AM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"