Forum Discussion

Copper Contributor

Feb 09, 2020

problem with using MINVERSE function

Hi everybody I have a problem with using MINVERSE function(I don't have office 365). When I arrive at the stage in the picture, I press Ctrl+Shift+Enter, but the matrix isn't shown completely and t...

Formulas and Functions

vicvanlint

Copper Contributor

Jun 15, 2021

SergeiBaklan

Sorry, but it still shows only the (1,1) entry.

The first time I tried it with the 4x4 array I used CTRL-SHFT-ENTER.

Is it possible that EXCEL only allows you to use it once on each spread sheet?

I erased the output matrix from the 4x4 matrix I had succeeded inverting before and tried again with ENTER : just one entry. The I tried again with CTRL-SHFT-ENTER. Still only one entry. It acts like it only allows you to succeed once!

SergeiBaklan

Diamond Contributor

Jun 16, 2021

vicvanlint

With Ctrl+Shift+Enter it shall be only one number returned, not an array. It will be better if you could submit sample file to play with it. And I'd suggest to continue discussion in one of the threads, let say with https://techcommunity.microsoft.com/t5/excel/minverse-works-sometimes-on-excel-365-but-produces-only-1-output/m-p/2447977. It's bit hard to follow same discussion in two different threads.