Order a column based on another column

Question

I want to order Column A based on the values of Column B.

In Google Sheets that is simply: =SORT(A1:A100,B1:B100,TRUE)

How to do that in Excel?

user_4648642 · Answer

This is the manual method in an animated form:

user_14578412 · Answer

Use the =SORTBY() function; its format is

=SORTBY(array, by_array1, [sort_order1], by_array2, [sort_order2]...),

but its simplest is

=SORTBY(array, by_array1, [sort_order1]),

which is the basic one. It works as you would expect. Further arrays are to sort within by_array(n-1) using by_array(n).