View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
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