Newbie help

[EagleBhoy]

Hi Guys,

I am looking for a little help please?

I have a table of 12 names, or players. Each player has to play at
least one game against each other over the course of a season. Is there
a function I can use which will allow me to quickly line up all 12
players against each other once over the course of a season??

Appreciate any help offered!!

 

[Barb Reinhardt]

How long is the season? 12 games or what?

 

[EagleBhoy]

Hi,

The season is 8 weeks long. Each player plays in a group of four, and
it doesn't matter how many times each player plays with another, as
long as they all play with each other a minimum of once ....

Any ideas??

 

[Max]

I have a table of 12 names, or players. Each player has to play at
least one game against each other over the course of a season. Is there
a function I can use which will allow me to quickly line up all 12
players against each other once over the course of a season??

Here's 2 set-ups to play with ..

Demo file at:
http://cjoint.com/?lhhUgNtOha
Generating_a_12_player_season_Eagleboy_gen.xls

Option 1 (Each player plays the other 11 once per season)
----------
List the 12 players in A2:A13

Put in B2:
=IF(OFFSET($A$2,ROWS($A$1:B1)-1+COLUMNS($A$1:B1)-1,)=0,"",
$A2&CHAR(10)&" vs "&CHAR(10)
&OFFSET($A$2,ROWS($A$1:B1)-1+COLUMNS($A$1:B1)-1,))

Format B2 to wrap text
(Format > Cells > Alignment tab > Check "Wrap text" > OK)
Copy B2 across to L2, fill down to L12

The filled results within B2:L12 returns the 66 match-ups


Option2 (Each player plays the other 11 twice per season)
---------
List the 12 players in A2:A13
Put in A14: =A2, copy A14 down to A24

Put in B2:
=$A2 & CHAR(10) & " vs " & CHAR(10)
& OFFSET($A$2,ROWS($A$1:B1)-1+COLUMNS($A$1:B1)-1,)

Format B2 to wrap text
(Format > Cells > Alignment tab > Check "Wrap text" > OK)
Copy B2 across to L2

Select A2:L2, copy down by 12 rows to L13

B2:L13 returns the 132 match-ups

 

[Max]

As the entire range B2:L12 is actually filled with formulae,

think the line

The filled results within B2:L12 returns the 66 match-ups

reads more correctly as:

 

[EagleBhoy]

Fantastic! Thanks!!!!!

 

[Max]

You're welcome, EagleBhoy !