There are many ways to sort data in Microsoft Excel, and one of the simplest and most convenient is the SORTBY function. It ...

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells ...

Because the GROUPBY function returns spilled arrays, you can't use formatted ... to make the data easier to read. The sort order field lets you tell Excel whether and how you want to sort the ...