P
paivoh
I have several big matrices (1200*50) on different worksheets. It is a
time-series data, so row headings are dates and column headings are
firms. Cells are stock earnings, every worksheet using a different
principle for calculating them.
I need to sort this data like this: every row (daily revenues) in the
first matrix (1. worksheet) in a descending/ascending order and all the
other matrices should sort accordingly.
This is because I need for example the smallest five values from the
first matrice's rows and then the according values of those five firms
from the other matrices.
So I should find a way to bind the cells together somehow... It would
even be tolerable if I could do this with two matrices only, or with a
3-d table they would constitute. Of course it would be easier to use a
method for a n-dimensional table.
Some other way? If every cell would "remember" its column heading
("firm") then maybe I could use that to find the necessary cells from
the other matrices...
Is this possible in Excel? Some other program (free/free trial) that
could be useful?
Help with this is desperately needed and would be greatly appreciated!
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
time-series data, so row headings are dates and column headings are
firms. Cells are stock earnings, every worksheet using a different
principle for calculating them.
I need to sort this data like this: every row (daily revenues) in the
first matrix (1. worksheet) in a descending/ascending order and all the
other matrices should sort accordingly.
This is because I need for example the smallest five values from the
first matrice's rows and then the according values of those five firms
from the other matrices.
So I should find a way to bind the cells together somehow... It would
even be tolerable if I could do this with two matrices only, or with a
3-d table they would constitute. Of course it would be easier to use a
method for a n-dimensional table.
Some other way? If every cell would "remember" its column heading
("firm") then maybe I could use that to find the necessary cells from
the other matrices...
Is this possible in Excel? Some other program (free/free trial) that
could be useful?
Help with this is desperately needed and would be greatly appreciated!
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***