Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Manipulating matrices of unknwon (a priori) size
Hello,
In one of my worksheet, a user has to input columns of data. The categories (columns) are fixed, but the number of data (lines) may vary, I eventually need to invert and multiply matrices, but the size of these matrices will depend on the number of data (lines), I know how to do it manually by selecting the cells. I know I could probably do it all using VBA But is there a quick way to implement it automatically purely in a worksheet ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Manipulating matrices of unknwon (a priori) size
On Mar 16, 12:39*pm, Euh wrote:
Hello, In one of my worksheet, a user has to input columns of data. The categories (columns) are fixed, but the number of data (lines) may vary, I eventually need to invert and multiply matrices, but the size of these matrices will depend on the number of data (lines), I know how to do it manually by selecting the cells. I know I could probably do it all using VBA But is there a quick way to implement it automatically purely in a worksheet ? Euh: You could use the =COUNTA function to determine the number of nonblank cells(in your case, number of data lines) in your range, and use this figure as your multiplier. Hope it helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i square matrices? | Excel Worksheet Functions | |||
Sumproduct with Matrices | Excel Discussion (Misc queries) | |||
matrices | Excel Discussion (Misc queries) | |||
How to solve y =f(x,y) using matrices? | Excel Worksheet Functions | |||
Combining certain matrices | Excel Discussion (Misc queries) |