Many of the VBA functions available here return results as arrays, which must be entered by selecting the desired output range, then pressing Ctrl-Shift-Enter (CSE). This can be inconvenient (or at least untidy) when the size of the output array varies. Some solutions to this, using VBA and/or Python were presented here. Microsoft have also been working on this, and for members of the Windows Insider Program, dynamic arrays have been available for some time now. Dynamic array formulas are entered as standard single cell formulas, but automatically resize to display the entire array (or “SPILL” if the output range contains any existing data).
The new dynamic arrays (currently only available in the Excel Insider version) have potential problems when spreadsheets created in an Insider version are opened in earlier versions. Charles Williams at Fast Excel has been investigating these problems, and has recently published a detailed review of potential problems, including a free CheckDA tool that allows you to check that the workbook you create using Excel DA will not cause problems when opened in prior Excel versions.