The formula =SORT (A3:B17) uses the default “sort by” and “sort order” settings; thus, the list is sorted in alphabetical order. The syntax for the new SORT function is =SORT (array, [sort_index], ...

Dynamic arrays allow Excel formulas to adjust automatically when new data is added. This means that as you input new information, the formulas update without any manual effort.

Learn how to use Excel’s dynamic array formulas to automate data pairing, save time, and unlock new insights in your analysis. Excel arrays ...

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Other array-based functions include SORTBY and RANDARRAY. The SORTBY function works like the SORT function, except it sorts data according to data contained in another array. For example, you might ...

INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works with vertical and horizontal datasets, can search in any direction, and ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

While this formula type generates a dynamic array, it is incompatible with Excel tables. You can simply reference the value within the same row and copy the formula downwards.