To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter customization tools to limit the number of rows included in your filter results.