Excel SORT Function | Excel One Minute Quick Reference

The SORT function in Excel sorts the contents of a range or array. Example, =SORT(B2:B20). You can also sort in ascending or descending order with the SORT function. =SORT(B2:B20,,-1) would sort descending or highest to lowest. The number 1 would sort ascending, which is the default sort. The SORT function has four arguments, but only 1 is required.

SORT function in Excel

YouTube video

Excel SORT Function \| Excel One Minute Functions Explained

Syntax for SORT function

=SORT(array,\[sort\_index\],\[sort\_order\],\[by\_col\])

Arguments for SORT function

- array - The array or range to sort - **Required** - \[sort\_index\] A number indicating the row or column to sort by - Optional - \[sort\_order\] - The order to use for sorting. 1 for ascending, -1 for descending. Default is ascending - Optional - \[by\_col\] - A logical value indicating the desired sort direction; FALSE to sort by row (default), TRUE to sort by column - Optional

Versions of Excel the SORT function works in

- Excel for Microsoft365 - Excel for Microsoft 365 for Mac - Excel for the web - Excel 2021 - Excel 2021 for Mac - Excel for iPad - Excel for iPhone - Excel for Android tablets - Excel for Android phones