There's also the function MININDICES(array) which gives you an array of the indices in sorted order. This can be used to read multiple arrays in the sorted order. Example:
V1 is an array of names, V2 is an array with the corresponding values
V3 becomes an array of indices - how to read the V1 and V2 arrays in the same sorted order.
Name: a Value: 3
Name: b Value: 13
Name: aaa Value: 74
Name: ab Value 234
Name: ba Value: 345
Beware: It seems the SORTxxx() and xxxINDICES() functions only sort
numerical values, they can not be used to sort the above arrays in name order (at least not in 2018 R2 SP1)!
