Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Matrix Functions
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a value out of a Matrix | Excel Discussion (Misc queries) | |||
Sum with matrix functions? | Excel Worksheet Functions | |||
How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
Using Matrix functions on complex numbers | Excel Worksheet Functions | |||
IF and VLOOKUP functions for a matrix overview | Excel Worksheet Functions |