Table of Contents
SORT function
Use the magic SORT function in Excel 365/2021 to sort your Excel data by one column or multiple columns. Let’s give it a try.
1. The simple SORT function below has only 1 argument (A2:D15). By default the SORT function sorts by the first column in ascending order.
Note: this dynamic array function entered into cell F2 fills multiple cells. Wow! This behavior in Excel 365/2021 is called spilling.
2. Use the second argument of the SORT function to sort by a different column. The SORT function below sorts by the second column.
Note: only edit the formula in cell F2. Excel will do the rest.
3. Use the third argument of the SORT function to sort in a different order. The SORT function below sorts by the first column in descending order.
Note: use 1 to sort in ascending order use -1 to sort in descending order.
4. To sort by multiple columns simply supply an array constant. For example sort by Last Name first and Sales second.
5. The advanced SORT function below sorts by Last Name first (in ascending order) and by Sales second (in descending order). Pretty cool huh?
6. Finally use the SORTBY function in Excel to sort a range based on the values in a corresponding range.
Note: use 1 to sort in ascending order use -1 to sort in descending order.
