SORTBY function

Category: Lookup and reference
Introduced: Excel 2021

Summary

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

Syntax

SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2],…)

Example

=SEQUENCE(10)

Microsoft Support Page

https://support.microsoft.com/en-us/office/sortby-function-cd2d7a62-1b93-435c-b561-d6a35134f28f

Back to Functions