Table arrays?

  • Thread starter Thread starter Paul T
  • Start date Start date
P

Paul T

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
 
Back
Top