Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Euh Euh is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i square matrices? sparkskey Excel Worksheet Functions 4 April 26th 23 07:47 PM
Sumproduct with Matrices Stacey Excel Discussion (Misc queries) 6 June 25th 07 02:39 PM
matrices Eiman Excel Discussion (Misc queries) 0 December 10th 05 12:01 AM
How to solve y =f(x,y) using matrices? Ane Excel Worksheet Functions 1 July 27th 05 02:37 AM
Combining certain matrices [email protected] Excel Discussion (Misc queries) 1 January 8th 05 01:06 AM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"