Learn how to master custom sorting in Excel with SORTBY, LET, and XMATCH. ... SORT: Rearranges rows or columns based on a selected column, either in ascending or descending order.

Excel’s Sort function can do that, but it can sort information only in columns, not in rows. Let’s reorder the sequential numbers 1 to 5. Begin by highlighting those cells. Click on Data in the ...