# using matrix in excel

#### thunderspeed

##### New Member
Hi ,
I have a block of numbers of m*n size that I want to deal with them as matrix and get the inverse of this matrix .
I followed the steps in this video : https://www.youtube.com/watch?v=gSNa3fQX0WQ
which is basically using the minverse(marking the matrix block) , then cntr+shift+enter after marking the result area .
This doesn't work for me , it gives #num! and for bigger blocks #value!
I think some solver must be loaded first from the options .
How can I do that ?

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### StephenCrump

##### Well-known Member
What are you trying to do with your matrix?

If it's solving simultaneous equations, you normally use MINVERSE on n equations in n variables, i.e. a square matrix.

Non-square matrices (i.e. m by n, with m <> n) do not have inverses (in the conventional sense). So MINVERSE will return #VALUE.

#### WarPigl3t

##### Well-known Member
The matrix is all around us. Follow the white rabbit.

#### thunderspeed

##### New Member
Piglet , I hope it was that simple

Yes , I see

Replies
2
Views
60
Replies
0
Views
38
Replies
2
Views
227
Replies
1
Views
55
Replies
1
Views
47