Forum Discussion
Does SORTBY always sort by row whereas SORT can sort by row and can sort by column?
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?
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.
2 Replies
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.
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.
