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

To reverse the order, click on Descending and then on OK . The process is different if each number is adjacent to, say, a list of names in column B, because Excel, in its wisdom, guesses that it’s ...