Skip to main content

SORTBY

Sorts the contents of a range or array based on the values in a corresponding range or array.

CategoryDynamicArray
SyntaxSORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2], ...)

Parameters

ParameterRequiredDescription
arrayRequiredThe range or array to sort.
by_array1RequiredThe range or array to sort by.
sort_order1Optional1 (default) for ascending, -1 for descending.
by_array2OptionalAdditional range or array to sort by.
sort_order2OptionalSort order for by_array2.

Example

SORTBY(array, by_array1, sort_order1, by_array2, sort_order2)

Auto-generated from the EngCanvas function registry.