excel question

Joined
Oct 18, 2007
Messages
2
Reaction score
0
i need to know how to set up all possible combinations for two numbers then add a third number

what i'm tring to do is set up league game by having each team play every other team before playing the same team twice

after that i need to set it up so that each team dosen't play the same game twice before playing every other game
so game 1 would be
1-2-A
2-1-A
3-4-B
4-3-B
5-6-C
6-5-C
and so on for however many teams there are as well as the minimum amount of other games needed
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top