Need a format for team vs team

[manchester united]

I need help trying to set a format for 10 teams playing each other in 10
weeks. eg...team1 vs team 2, team 3 vs team 4, team 5 vs team 6...etc...
Also for 12 teams playing against each other for 10 weeks.

Thanks for your help....

 

[Stefi]

Do you mean something like this:
A B C D E F
week pair1 pair2 pair3 pair4 pair5
1 t1-t2 t3-t4 t5-t6 t7-t8 t9-t10
2 t1-t3 t3-t5 t5-t7 t7-t9 t9-t1
3 t1-t4 t3-t6 t5-t8 t7-t10 t9-t2
4 t1-t5 t3-t7 t5-t9 t7-t1 t9-t3
5 t1-t6 t3-t8 t5-t10 t7-t2 t9-t4
6 t1-t7 t3-t9 t5-t1 t7-t3 t9-t5
7 t1-t8 t3-t10 t5-t2 t7-t4 t9-t6
8 t1-t9 t3-t1 t5-t3 t7-t5 t9-t7
9 t1-t10 t3-t2 t5-t4 t7-t6 t9-t8

The formula in B2:

="t"&INT(2*COLUMN()-1/2)-2&"-t"&IF(MOD((INT(2*COLUMN()-1/2)-1)+ROW()-2,10)>0,MOD((INT(2*COLUMN()-1/2)-1)+ROW()-2,10),10)

Fill it to the right and down!

t1, t2, etc. stands for team1, team2, etc.

Regards,
Stefi


„manchester united†ezt írta: