There are many ways to sort data in Microsoft Excel, and one of the simplest and most convenient is the SORTBY function. It ...

while the array form works with larger table-like data ranges. There are also advanced Excel functions like VLOOKUP, HLOOKUP, ...