Excel FunctionsLesson 106Free preview

SORT

This lesson is part of Excel · All levels

Summary

SORT is an Excel dynamic array function that sorts the contents of a range and then displays the result in multiple cells (spill). The syntax is. This function is available in Excel 365 and Excel 2021 above.

Key points

Syntax: SORT(array, [sort_index], [sort_order], [by_col])
Sort_index specifies the basic column of the sequence
Sort_order 1 to go up, -1 to go down
The result is a dynamic array that extends into the surrounding cells.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.