There are many ways to sort data in Microsoft Excel ... SORTBY formula doesn't have to be in the same worksheet—or even the same workbook!—as the source data. However, if you use SORTBY ...

But here’s the good news: with a few advanced techniques, you can completely transform how you approach sorting. By combining the power of Excel’s SORTBY function with tools like LET and ...