minverse function

[gesstav]

Hello, when i use the minverse function i get a single value,not an array.i pressed control+shift+enter but still the same.how is this fixed?
Thanks,
George

 

[RoryA]

Did you select enough output cells before array-entering the formula?

 

[Aladin Akyurek]

Hello, when i use the minverse function i get a single value,not an array.i pressed control+shift+enter but still the same.how is this fixed?
Thanks,
George

Given A2:B4...

In E2 enter:

=MINVERSE(A2:B4)

Select E2:F4 and apply control+shift+enter, not just enter.

 

[gesstav]

ok i tried it again and worked,thanks!

 

[Aladin Akyurek]

ok i tried it again and worked,thanks!

You are welcome. Thanks for providing us feedback.