using matrix in excel

thunderspeed

New Member
Joined
Sep 25, 2014
Messages
30
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 ?

Thanks in advance
 

Some videos you may like

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
Joined
Sep 18, 2013
Messages
3,804
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,159
Messages
5,527,149
Members
409,749
Latest member
esmarques

This Week's Hot Topics

Top