Manipulating matrices of unknwon (a priori) size

  • Thread starter Thread starter Euh
  • Start date Start date
E

Euh

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 ?
 
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 ?
Click to expand...
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
 
Back
Top