Forum Discussion
MINVERSE works sometimes on Excel 365, but produces only 1 output on most
Sorry, in your file AD35 is empty, in Z25 is MINIVERSE entered as array formula and in AE25 is MMULT, also entered with CSE
If re-enter formulas without CSE the result is
My respect.
No, inserting of implicit intersection operator is not configurable. Maybe something is in registry settings, but I don't know about such.
On the other hand this operator appears if you open created in old Excel file in new one to ensure compatibility. Old Excel performs implicit intersection silently in background, to have same result in new Excel you shall use this operator.
More about that is here Implicit intersection operator: @ - Office Support (microsoft.com)
- I apologize for my incompetence. I don't know how that got there; it's one of the things that the modern EXCEL is doing to me: inserting stuff I don't intend. Is there any way I can turn off the automatic insertions? I'm perfectly willing to type in the commands, as I used to do until I stopped working about ten years ago. My only excuse is that I'm 93 years old.
Thank you for the file. In the formula there is implicit intersection operator "@" which returns first element of the array
If use formula without it result will be expected matrix.
Operator could appear if open in older Excel the file created in Excel which supports dynamic arrays.
- I attached the file to my response, but I don't remember having a chance to click POST afterwards. This appears to be a reply to my reply, but I'll POST it.
SergeiBaklan I'll try again
Sorry, but I see only one file from you (which we are discussing)
- Please ignore this one and look at the cleaned up spread sheet I sent later. It eliminates all the sad history.