Array formula on Excel for Mac
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.
This works 100%.
- Select the cells you want to populate with the formulated data.
- Press Control + U.
- Add your array formula on any cell (preferably first).
- Press Control + Shift + Return.
Remember Control and Command are different keys on Mac!!
Select the range, press CONTROL+U and then press ⌘+RETURN.