The new Excel SORT function is one of the new dynamic arrays that are available in Microsoft 365.

Below is the syntax. The array is required and the others are not. The sort_index is a number indicating the row or column to sort by (the default is 1). The sort_order is a number indicating the desired sort order; 1 for ascending order (the default), -1 for descending order. by_col is a logical value indicating the desired sort direction; FALSE to sort by row (default), TRUE to sort by column.

=SORT(array,[sort_index],[sort_order],[by_col])

Here’s a simple example with the sample data from the Analyze Data button in the Home tab of Excel.

Learn with YouTube

Here’s a short video by Chris Menard on the new SORT function that’s called Excel SORT Function | Excel One Minute Functions Explained.