Dynamic Matrix(Two Dimensinal Array)

[ryusukekenji]

May I know how to get the score from left hand side and create a dynamic matrix table on the right hand side?

 

[lenze]

Hi and welcome to the board!!
Can you provide some example data as to what you want??
lenze

 

[ryusukekenji]

hi, i uploaded it onto http://www.box.net/files now
file name is "Contest Matrix.zip"

 

[lenze]

We need the LINK to the file, but you probably can just explain what you need.
lenze

 

[ryusukekenji]

Get the database (Soccer Score) and create a matrix table.

http://www.box.net/shared/nom169t8rq

 

[lenze]

So, which scores do you want in Columns and which in Rows in your matris?
lenze

 

[ryusukekenji]

Is it possible to make it dynamic??? If that so I can cope with different source data(Premiership, League Championship... ect) matches....

Since it just a sample, would you try to clear up all contents in the sheets (except: schedule area RANGE("A1:E23")).

And then is it ok that start the matrix table from RANGE("G4")

** Some leagues get 20 teams, while some others 24 teams, so is it possible to make flexible and dynamic???
** For the not available match, would you make it cells.value = "n/a"

Thank you... ^_^