close

I have been using Excel (Office 2000) at work for several years which
involves matrix inversion and Visual Basic. I have found that the largest
matrix that can be inverted is 52 x 52. I need to invert larger matrices,
100 x 100 would be better; 150 x 150 would be much better. Are there plans
to allow this in future Excel versions. I am using the MINVERSE function.

On Mon, 23 Jan 2006 07:27:10 -0800, quot;W0PSIquot; gt;
wrote:

gt;I have been using Excel (Office 2000) at work for several years which
gt;involves matrix inversion and Visual Basic. I have found that the largest
gt;matrix that can be inverted is 52 x 52. I need to invert larger matrices,
gt;100 x 100 would be better; 150 x 150 would be much better. Are there plans
gt;to allow this in future Excel versions. I am using the MINVERSE function.

I've not used these functions, but Longre's free morefunc.xll add-in, available
at xcell05.free.fr/ has included in it matrix functions that do not have
the size limitation of Excel.--ron

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()