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

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.

Unlike a database, which maintains the equivalent of each row in a Microsoft Excel spreadsheet as a separate record, Excel worksheets keep multiple records together. When you sort your data, Excel ...