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" <EagleBhoy.1y3i5y_1131314400.6083@excelforum-nospam.com> wrote
in message news:EagleBhoy.1y3i5y_1131314400.6083@excelforum-nospam.com...
>
> 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!!
>
>
> --
> EagleBhoy
> ------------------------------------------------------------------------
> EagleBhoy's Profile:
> http://www.excelforum.com/member.php...o&userid=28603
> View this thread: http://www.excelforum.com/showthread...hreadid=482668
>

[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]

"EagleBhoy" wrote:
> 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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[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:
> The non blank ("") results within B2:L12 returns the 66 match-ups
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[EagleBhoy]

Fantastic! Thanks!!!!!

[Max]

You're welcome, EagleBhoy !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"EagleBhoy" <EagleBhoy.1y59cy_1131396300.5085@excelforum-nospam.com> wrote
in message news:EagleBhoy.1y59cy_1131396300.5085@excelforum-nospam.com...
>
> Fantastic! Thanks!!!!!