In this video I have explain in detailed about Microsoft Excel 365 dynamic array Function #SORTBY(). The Excel #SORTBY function sorts the contents of a range or array based on the values from another range or array. It's a also work just like #SORT Function, but by using #SORT Function you can sort data By Row & By Column at once, but the SORTBY Function you can sort data by Column only and you can sort multiple columns data at the same time.