| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Invert a matrix larger than 52 x 52 using MINVERSE
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Invert a matrix larger than 52 x 52 using MINVERSE
On Mon, 23 Jan 2006 07:27:10 -0800, "W0PSI"
wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matrix Problem | Excel Discussion (Misc queries) | |||
| Matrix calculation | Excel Discussion (Misc queries) | |||
| How to identify entries in a matrix also present in another list | Excel Worksheet Functions | |||
| Limits of MINV matrix function | Excel Worksheet Functions | |||
| Recreate the upper part of a symetric data matrix 75x75 | Excel Discussion (Misc queries) | |||
Hybrid Mode
