Use the SORT Function

New and currently only available in Office 365 is the SORT function. It's part of the dynamic array functions in Microsoft 365 Excel. Prior to the SORT function you might have had to use a combination of other functions to perform sorting, turn your range of data into a table for sorting or use the custom sort functions. However using this SORT function does give flexibility in the use of other dynamic array functions.