Excel Function

SORT

Sorts an array by specified index/order.

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

Arguments

array

Required

Specify a reference range. You can drag or click start/end cells.

sort_index

Optional

Enter a numeric value.

sort_order

Optional

Enter a numeric value.

by_col

Optional

Specify TRUE or FALSE.

Practice Preview

sort and display the dataset. Use SORT to Sorts an array by specified index/order. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. use 4 for sort_index, use -1 for sort_order, use FALSE for by_col. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=SORT(A2:D8, 4, -1, FALSE)

Practice This Function

Practice in Sequential Mode Back to Function List