News

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...
Click OK to copy the contents of the column. Now, you can sort the copied list by clicking any cell in it and choosing Sort from the Data menu. By default, Excel selects the Header Row option.