Forum Discussion
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 there is only one cell.
What do I have to do?(The second table is selected)
Thank you in advance.
The second table is selected
5 Replies
Just happened that I had the grid set up for an 8x8 matrix inversion on an open workbook!
I use Office 365 so my inverse matrix spilt correctly and I got agreement with your (1,1) cell. I then changed the formula to a CSE array. Did you select the entire 8x8 region, click in the formula bar and commit the formula with Ctrl+Shift+Enter? That worked for me.
Traditional Excel's array handling is about as user-friendly as a cornered rat but still better than absolute/relative/mixed referencing!
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.
