ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Minverse, how come this function only returns one value? (https://www.excelbanter.com/excel-worksheet-functions/141100-minverse-how-come-function-only-returns-one-value.html)

Giovannired

Minverse, how come this function only returns one value?
 
For instance in a 3 x 3 array, minverse only returns one value, the first
one, where are the other 8 values and how do I display them?

JE McGimpsey

Minverse, how come this function only returns one value?
 
You need to select a three by three range, and array-entered
(CTRL-SHIFT-ENTER or CMD-RETURN).

In article ,
Giovannired wrote:

For instance in a 3 x 3 array, minverse only returns one value, the first
one, where are the other 8 values and how do I display them?



All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com