Excel Function

SORTBY

Sorts array by another array.

SORTBY(array, by_array1, [sort_order1], ...)

Arguments

array

Required

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

by_array1

Required

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

sort_order1

Optional

Enter a numeric value.

Practice Preview

sort data by another column. Use SORTBY to Sorts array by another array. 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 -1 for sort_order1. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=SORTBY(A2:D8, D2:D8, -1)

Practice This Function

Practice in Sequential Mode Back to Function List