Re: matrices and array operations in excel

["John S. Denker" <jsd@MONMOUTH.COM>]

At 03:04 PM 3/1/01 -0700, Larry Smith wrote:
>   Please repeat your instructions for matrix
> inversion in Excel and I'll try it again.

This isn't a repeat AFAIK, but here's the answer:

Suppose the matrix to be inverted is in cells A1 through C3.

By clicking-and-dragging (or otherwise), highlight the cells that will
receive the inverse, say E1 through G3.

While they are highlighted, type
  =MINVERSE(A1:C3)
followed by control-shift-enter.
            ^^^^^^^^^^^^^^^^^^^
            That's the part you might never guess.

Of course, after typing the "(" you can use the mouse to select the region
A1:C3 in the usual way, then type ")" followed by control-shift-enter.

===============

In case you are wondering where the control-shift-enter comes from, try
this:  Suppose you want to fill a region with the value -7.9...  You can
highlight the region, then type -7.9 followed by control-shift-enter.