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

SORT: Rearranges rows or columns based on a selected column, either in ascending or descending order. SORTBY: Adds versatility by allowing you to sort data based on values in a separate range ...

The default is ascending. So if you wanted to sort by “Sales” to produce a list of sales by state ranked from highest to lowest, you would want to sort by the second column in ascending order, ...