To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

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], ...

3. Modify SUMIFS or FILTER criteria to work horizontally Dynamic arrays and advanced Excel functions offer a robust framework for calculating running totals by row.

And, the INDEX-MATCH functions used together make extracting data from a table a breeze. The syntax for the INDEX function is: INDEX (array, row_num, [column_num]).

XLOOKUP () is one of several newish dynamic array functions. If you’ve ever entered an expression using Ctrl + Shift + Enter, then you’re already familiar with how Excel used to work with ...