Exceljet

Quick, clean, and to the point

Sort by one column

Excel formula: Sort by one column
Generic formula 
=SORT(data,index,order)
Explanation 

To sort by one column, you can use the SORT function or SORTBY function. In the example shown, data is sorted by the Group column. The formula in F5 is:

=SORT(B5:D14,3)

Notice data is sorted in ascending order (A-Z) by default.

How this formula works

The SORT function requires very little configuration. In the example shown, we want to sort data in B5:D14 by the third column, Group. For array, we provide entire range, B5:D14. For sort_index, we provide 3:

=SORT(B5:D14,3)

With this formula in F5, the SORT function outputs the sorted array in F5:H14.

Ascending vs. Descending

Data is sorted in ascending order (A-Z) by default. This behavior is controlled by an optional third argument, sort_order. The default value for sort_order is 1, so both formulas below return the same result as shown in the example above:

=SORT(B5:D14,3)
=SORT(B5:D14,3,1)

To sort in descending (Z-A) order, set sort_order to -1. In the example below, we are sorting data in descending order by score, which is the second column:

=SORT(B5:D14,2,-1)

Example - sort by one column in descending order

Note: This function is a new "Dynamic Array Function" in Excel. It is a beta feature available only through the Office Insiders program. Dynamic Array functions are expected to be released in 2019 to Office 365 subscribers.
Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables