The SORT function allows you to sort the values in a given array. It is useful in situations when you want to use a function instead of the ‘Sort’ or ‘Custom Sort’ functionalities available in the Home and Data tabs. The function has 4 arguments: the array to be sorted, the sort_index, which specifies the row or column to sort by, the sort_order field indicating the desired sort order, and the by_col field, which determines whether you will be sorting a row or a column.

Some other related topics you might be interested to explore are LARGE, SMALL, RANK, and FREQUENCY.

This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Financial Analyst, Business Analyst, Consultant, Corporate Executive, or everyone preparing a corporate presentation.

You can now download the Excel template for free.