News
How-To Geek on MSN5d
How to Use the SORT and SORTBY Functions in Microsoft Excel
To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...
Your spreadsheet should consist of columns and rows. Row 1 should always be used for headings and each one should be sortable.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback