Table arrays?

Hi all

Trying to find a way to produce a list of teams(fixtures) from a table of
dates.

A1 b c d e f
2 team a team b team c term d
3 team a 00-Jan 01-Jan 07-Jan 14-Jan
4 team b 01-Feb 00-Jan 14-Feb 07-Jan
5 team c 07-Feb 14-Jan 00-Jan 01-Feb
6 team d 14-Feb 07-Feb 01-Jan 00-Jan


Ignore 00-Jan

Don't know where to start!

Match or vlookup?

Any pointer would be helpful to start me off.

cheers

One play to try ...

Assume the source table is in Sheet1, in A1:E5

In Sheet2
-------
Put 3 headers in A1:C1, i.e.: Home, Away, Date

Put

in A2:
=OFFSET(Sheet1!$A$2,INT((ROWS($A$1:A1)-1)/4),)

in B2:
=OFFSET(Sheet1!$B$1,,MOD(ROWS($A$1:A1)-1,4))

in C2:
=OFFSET(Sheet1!$B$2,INT((ROWS($A$1:A1)-1)/4),MOD(ROWS($A$1:A1)-1,4))

Format C2 as date in the desired date format

Select A2:C2, fill down by 16* rows to C17
(*16 = 4 x 4 = no. of cells within the table)

This will yield the fixtures? table, viz.:

Home Away Date
team a team a 00-Jan
team a team b 01-Jan-05
team a team c 07-Jan-05
team a term d 14-Jan-05
team b team a 01-Feb-05
team b team b 00-Jan
team b team c 14-Feb-05
team b term d 07-Jan-05
team c team a 07-Feb-05
team c team b 14-Jan-05
team c team c 00-Jan
team c term d 01-Feb-05
team d team a 14-Feb-05
team d team b 07-Feb-05
team d team c 01-Jan-05
team d term d 00-Jan

Now just add additional info (if required, e.g.: venue, etc)
in column(s) to the right
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Paul T" <[email protected]> wrote in message
news:[email protected]...
> Hi all
>
> Trying to find a way to produce a list of teams(fixtures) from a table of
> dates.
>
> A1 b c d e f
> 2 team a team b team c term d
> 3 team a 00-Jan 01-Jan 07-Jan 14-Jan
> 4 team b 01-Feb 00-Jan 14-Feb 07-Jan
> 5 team c 07-Feb 14-Jan 00-Jan 01-Feb
> 6 team d 14-Feb 07-Feb 01-Jan 00-Jan
>
>
> Ignore 00-Jan
>
> Don't know where to start!
>
> Match or vlookup?
>
> Any pointer would be helpful to start me off.
>
> cheers
>
>

Feedback received from OP via private email:

Paul T wrote:
>
> Nice One MAX!
>
> Worked A Treat!
>
> Paul T

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----