MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?

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.

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

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.