SOLVED

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

Copper Contributor

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?

2 Replies
best response confirmed by Regina_Henschel (Copper Contributor)
Solution

Re: Does SORTBY always sort by row whereas SORT can sort by row and 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.

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

@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.

1 best response

Accepted Solutions
best response confirmed by Regina_Henschel (Copper Contributor)
Solution

Re: Does SORTBY always sort by row whereas SORT can sort by row and 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.