Thread: Minverse
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ilia ilia is offline
external usenet poster
 
Posts: 256
Default Minverse

Interestingly enough, Excel 2007 seems to have removed this limit (I
don't remember reading about it). I just solved a 1000-variable
simultaneous equation, with answers in column 1002. Adapting this
formula to Excel 2003, using:

=MMULT(MINVERSE($A$1:$IT$254),$IV$1:$IV$254)

returns #VALUE in Excel 2003, but works in Excel 2007.


On Nov 27, 10:52 pm, Albert wrote:
Hello!
I have made a very cool econometric interface for Excel. However, I have a
little problem: some advanced Panel Data techniques use MANY variables, and
large matrixes. Some of these matrixes have to be inverted, and I am sadly
surprised to see that the Minverse function can only work with a Matrix of up
to 52x52. Does someone have (or can help me make) a function to replace the
built in one, but that can work with larger matrixes?
I thank you in advance,
Albert C.