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

How to sort a single column in Excel without disrupting the rest of the spreadsheet Your email has been sent We tend to view spreadsheet data as a whole, and that’s as it should be. Seldom does ...

Not all sort tasks in Microsoft Excel begin with the characters to the left, but getting around that issue is easier than you think. Susan Harkins shows you how.