Table arrays?

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
 
Top