Launch Excel and open the spreadsheet that contains the list that you want to sort. Click to select a range of data, such as A1 through A20, or click the header to select the entire column of data.

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