News

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...
Excel can automatically rearrange cells in numerical or alphabetical order. You can also create customized sorting lists so that Excel can sort data in the manner you require.