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

Stay tuned Excel supports a second custom support: sorting by multiple columns. In a future article, I’ll show you how to use this same feature to sort by multiple columns.

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

In the September 2003 column I erroneously stated that Excel’s Sort function can sort information only in columns (up and down) not in rows (left and right). I should have known better because I’ve ...