Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Excel's MINVERSE functionPosted 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 functionPosted 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 functionPosted by weijian on February 13, 2002 5:41 PM
Re: Excel's MINVERSE functionPosted 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.