I could imagine listing these 45 combinations, then using RAND() next to
them, then RANK() to get a 1 - 45 to start with anyways. May want to enter
the RAND() in once, then copy/paste special values, lest they should continue
to change every time you make any changes to the spreadsheet. otherwise, you
can go with the standard 1 plays 2, 3 plays 4, then 5 plays 6, 1 plays 4, 2
plays 5, 3 plays 6 and so on. the assignments of teams to numbers is really
your random numberat that point.

"Joel" wrote:

Here are the 45 combinations

Team 1 Team 2
1 2 3 4
1 2 3 5
1 2 3 6
1 2 4 5
1 2 4 6
1 2 5 6
1 3 4 5
1 3 4 6
1 3 5 6
1 4 5 6
2 3 4 5
2 3 4 6
2 3 5 6
2 4 5 6
3 4 5 6

1 3 2 4
1 3 2 5
1 3 2 6
1 4 2 5
1 4 2 6
1 5 2 6
1 4 3 5
1 4 3 6
1 5 3 6
1 5 4 6
2 4 3 5
2 4 3 6
2 5 3 6
2 5 4 6
3 5 4 6

1 4 3 2
1 5 3 2
1 6 3 2
1 5 4 2
1 6 4 2
1 6 5 2
1 5 4 3
1 6 4 3
1 6 5 3
1 6 5 4
2 5 4 3
2 6 4 3
2 6 5 3
2 6 5 4
3 6 5 4


"Chris M." wrote:

I would like to create tennis schedule that schedules the players randomly.
There are a total of 6 players. Only 4 can play on any given day. We have 41
court dates throughout the year. What kind of formula can I use to make sure
the players alternate as evenly as possible?

Thanks for your help!