Auto-Filling Matrices

[Tripp]

Hey there,

Im currently building a large excel file that will end up with a lot of matrices and I'm trying to see if there is a way to drag down a matrix so that the next matrix will use the next variable from a table.

E.g. Variables are x,y,z (in a vertical list).

matrix is: 1st row (x^2,x^3,x^4), 2nd row (x^5,x^6,x^7)

Is it possible, without having to change manually, to drag the matrix down so that the next matrix sill substitute x for y and then z?

I have named the matrices as a range but cannot seem to make it work.

Any suggestions would be most welcome.

Regards,

Tripp

 

[Hui]

Tripp

Firstly, Welcome to the Chandoo.org Forums

You may be able to use Data tables to help you

You can read about them here:
http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/

Posting a sample workbook may make it easier to understand your problem

 

[NARAYANK991]

Hi ,

See if the attached file helps.

The individual cells have formulae , and to treat the set of cells as a matrix , you will have to use the range in your other formulae.

Narayan

 

[Tripp]

Hi,

Thank you very much for such a welcome and quick response.

Hui, I am currently reading up on data tables and may use them in my spreadsheet in the future for presenting the mountains of information I will end up with.

Narayan, this formula seems to do the trick. I wouldn't have minded entering the data manually if it had only been a few matrices but there over 100 on here so I think I can adapt your working to suit my needs.

Thank you both.

Regards,

Tripp