Does SORTBY always sort by row whereas SORT can sort by row and can sort by column?

[Regina_Henschel]

SORTBY always sorts by row whereas SORT can sort by row and can sort by column.

Do I interpret it correctly? Or is there a way, that SORTBY can sort by column?

[#2 · Accepted solution]

@Regina_Henschel 

SORTBY can sort both by row and by column, depending on the shape of the by_array arguments.

In the screenshot below, the by_array argument B2:E2 is horizontal, so the range is sorted horizontally.

[#3]

@HansVogelaar: Thank you. I see. The description on https://support.microsoft.com/en-us/office/sortby-function-cd2d7a62-1b93-435c-b561-d6a35134f28f should really have an example for horizontal sorting.