Hello,
Because of work I need to start using Excel 2016
One thing I was using a lot in Google docs was arrayformula. But I can not figure out how to use it in Excel (or with what formula I should substitute it)
For example in Google sheets this formula randomly picks an item from one range:
With comments:
But I cant even make something like this {=SUM(G15:G24*H15:H24)} to work without using ctrl+shift+enter, If I try to type braces inside formula it gives me error
Your help would be much appreciated!
Juris
Bookmarks