Tournament Schedulizer?

D

Dominic

Hi,

I have a list of x teams.

I want to create a list of games with all teams in the lists playing all
other teams in the list but with no repetition.

Is this possible using Random?
 
B

Bernie Deitrick

Dominic,

To get the list of all games, put a 1 into cell A1, a 2 into cell A2 and your value of x into cell
A3.

Then in cell A2, enter the formula

=IF(B1=($C$1),IF(A1+1<$C$1,A1+1,"Done"),A1)

In cell C2, enter the formula
=IF(A2="Done","Done",IF(B1<=($C$1-1),B1+1,A2+1))

Copy those formulas down for x*(x-1)/2 rows, and your last row should show "Done", with all the
possible pairings listed above. Of course, _scheduling_ those games is another matter....

HTH,
Bernie
MS Excel MVP
 
D

Dominic

Thanks, that gives me a list of all the combinations - except I think the
first line should read "To get the list of all games, put a 1 into cell A1, a
2 into cell B1 and your value of x into cell C1"

As far as schedulizing, how can use Excel to schedule for me so that the gap
between games is roughly the same for all games and for all teams? This is a
tough one I know.

Thanks again,

Dominic
 
Top