M
Martin Mrazek
Hi,
I work often with named arrays (like range("matrix")).
I need
1. to address sub-matrices - for example entire i-th column of
"matrix". But in formulas (like {=matrix(1.column) -
matrix(2.column)}, or matrix(2..3,2..5) - it denotes submatrix of
"matrix" consisting of intersection of rows 2 and 3 and columns 2 to
5.
2. to have some functions like rowSums, colSums for instant summing of
matrix rows and cols (again for named array as parameter).
Briefly I want to use array-formulas with names of arrays as operands
instead of referencing cells.
Do I need to program it myself or is it anywhere in Excel or is it
already programmed by anybody?
thanks Martin
I work often with named arrays (like range("matrix")).
I need
1. to address sub-matrices - for example entire i-th column of
"matrix". But in formulas (like {=matrix(1.column) -
matrix(2.column)}, or matrix(2..3,2..5) - it denotes submatrix of
"matrix" consisting of intersection of rows 2 and 3 and columns 2 to
5.
2. to have some functions like rowSums, colSums for instant summing of
matrix rows and cols (again for named array as parameter).
Briefly I want to use array-formulas with names of arrays as operands
instead of referencing cells.
Do I need to program it myself or is it anywhere in Excel or is it
already programmed by anybody?
thanks Martin