I need to call LINEST in Excel 2011 for Mac, I would say - this was a detective story. My laziness, my curiosity, all was here! I had a homework from university course to use LINEST.
I even stopped trying to do so on MAC, because after googling I could not find any solution how to do it. (I have tried EACH AND EVERY combination of Fn Ctrl Alt Cmd Return!)
Finally, I found a solution here on stack overflow! I want to mention it again, as it was a long time I spent looking for the solution. I have spent 4 days outside of home, to use just windows PC where it is easy as a pie - F2, CTRL+SHIFT+ENTER.
If you want to check if I tell truth - go to HELP in Excel for Mac, type array formula, find LINEST and look at the solution combination!
The solution: select the range, press CONTROL+U and then press ?+RETURN.
Here is the link to the original post: Excel formulas giving #VALUE! error when ported to Mac
This question is related to
excel
macos
array-formulas
excel-2011
Found a solution to Excel Mac2016 as having to paste the code into the relevant cell, enter, then go to the end of the formula within the header bar and enter the following:
Enter a formula as an array formula Image + SHIFT + RETURN or CONTROL + SHIFT + RETURN
CTRL+SHIFT+ENTER, ARRAY FORMULA EXCEL 2016 MAC. So I arrive late into the game, but maybe someone else will. This almost drove me nuts. No matter what I searched for in Google I came up empty. Whatever I tried, no solution seemed to be in sight. Switched to Excel 2016 quite some time ago and today I needed to do some array formulas. Also sitting on a MacBook Pro 15 Touch Bar 2016. Not that it really matters, but still, since the solution was published on Youtube in 2013. The reason why, for me anyway, nothing worked, is in the Mac OS, the control key by default, for me anyway, is set to manage Mission control, which, at least for me, disabled the control button in Excel. In order to enable the key to actually control functions in Excel, you need to go to System preferences > Mission Control, and disable shortcuts for Mission control. So, let's see how long this solution will last. Probably be back to square one after the coffee break. Have a good one!
This doesn't seem to work in Mac Excel 2016. After a bit of digging, it looks like the key combination for entering the array formula has changed from ?+RETURN to CTRL+SHIFT+RETURN.
Source: Stackoverflow.com