资讯

How-To Geek on MSN2 天

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 ...