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

If you run sorts in Excel a lot, you might benefit from shortcuts or even a macro. Here are some ways to make your sorting life easier.

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.

How to sort filtered data in Excel This allows you to put your sheet in rising or ascending order based on one column's values. 1.