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 ...