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

Excel’s default SORT and SORTBY functions are effective for basic sorting but lack the ability to handle custom sequences, requiring advanced techniques for tailored sorting solutions.

The SORT function takes dynamic arrays further. Continuing with the employees' data example, instead of manually arranging employee names or salary data, Excel handles the sorting automatically ...

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.

When you want to total the amount of sales from your top 10 performers, you usually would have to sort the data first, then use the SUM function to add up the first 10 values in the sorted range ...

This month’s column introduces Excel’s GROUPBY function as a PivotTable alternative.