Previews of dynamic arrays in Excel have been available for some time through the “Insider” programme. They are now being published to general subscribers through Office 365 monthly updates:
Most of my spreadsheets make extensive use of user defined functions (UDFs) that often return arrays of data, that up till now needed to be entered by selecting the output range and pressing Ctrl-Shift-Enter. These “legacy” CSE functions continue to work as they did before, but if you want to change to using the new dynamic arrays the procedure is:
As far as I know, there is no way to return part of an array using the new functionality, other than the top left cell, that can be returned with the Single() function. Fortunately the old Ctrl-Shift-Enter method still works.