Forum Discussion
problem with using MINVERSE function
I have the same problem with Windows 10 and Basic 2019 365, but I don't understand the answer provided, and I have 365, I think.
The first time it worked on a 3x3 array using MINVERSE(array) with CTRL SHFT Insert.
Then I tried it on a 2x2 array. It entered only the first element in the output array.
I tried copying the same 3x3 array to another location. This time MINVERSE either delivers only one element or produces an error.
In Excel 365 if you use Ctrl+Shift+Enter only first element of the array is returned. Try with simple Enter.
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!
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.