In this worksheet, we have a list of names, scores, and groups.
Currently the data is not sorted.
Our goal is to sort this data in descending order by score.
There are two new functions in Excel for sorting:SORTandSORTBY.
Either function will work in this case, but well use the SORT function.
Once we have a match, Ill press the TAB key.
The first argument is called array.
This is the data we want to sort.
In this case, thats the range B5:D14.
Next, we need to provide the sort index argument.
Sort index is just a number that corresponds to the columns in the data.
you’ve got the option to see the options are 1 for ascending, and -1 for descending.
When I enter -1 and hit return, we get our sorted data.
Notice these results are dynamic.
If I temporarily increase a score in the source data, the results update automatically.
Ill undo that change.
Lastly, a quick note on sort order.
As you saw earlier, the value for ascending sort is 1.
If I make that change, you’re able to see the data sorted in ascending order.
However, note the sort order argument is optional.
If I remove the 1, the sort order is unchanged.
This means the SORT function will sort in ascending order by default.
