Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

SORT The SORT function can help if you need to arrange data in a range in ascending or descending order to make it easier to find specific data in your Excel sheet.