Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

Excel's MINVERSE function

Posted by Tom on February 13, 2002 4:48 PM

Is it possible to invert a square matrix (square array) using Excel's MINVERSE function that is larger than 52 x 52? And if so how?

Re: Excel's MINVERSE function

Posted by Juan Pablo G. on February 13, 2002 5:22 PM

Couldn't do it directly. I guess you would have to create an UDF to do the same thing, but, my math skills (Especially Matrix calculations) are very rusty...

Juan Pablo G.

Re: Excel's MINVERSE function

Posted by weijian on February 13, 2002 5:41 PM

Re: Excel's MINVERSE function

Posted by Tom on February 13, 2002 6:26 PM

Thanks for your help. I'm affraid a UDF for MINVERSE is beyond me as well. If anyone is up for the challenge, I would appreciate it.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.