Invert a matrix larger than 52 x 52 using MINVERSE

W

W0PSI

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.
 
R

Ron Rosenfeld

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.

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


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top