The **SORT** function in Excel is used to sort the contents of a range or array. It can sort data based on one or multiple columns, and it provides options to sort in ascending or descending order.

<div style="display: flex; justify-content: center;">
=SORT(array,&nbsp;[sort_index],&nbsp;[sort_order],&nbsp;[by_col])</div>

| | |
|-------------|-----------------------------------------------------------------------------------------------|
| array | The range or array to sort. |
| [sort_index] | (Optional) The column or row to sort by. The default is the first column or row. |
| [sort_order] | (Optional) A number indicating the desired sort order; 1 for ascending (default) or -1 for descending. |
| [by_col] | (Optional) A logical value indicating the direction of the sort; **FALSE** to sort by row (default) or **TRUE** to sort by column. |

It is really straightforward and simple. Just select the range, specify how you want to sort it, and you will get it sorted. It works on various types of data, including numbers, text, and even dates.

The **SORT** function can also sort data based on multiple columns. Suppose you have a dataset with names in column A and scores in column B, and you want to sort by scores first and then by names.

> Note
>
> To sort data in descending order, you can use the sort_order argument.

Which argument in the SORT function specifies the range or array to sort?

This course is designed for beginners who want to start exploring formulas in Excel. You'll begin with the basics and then discover some really useful formulas for daily use. You'll learn about array formulas and how they work, and you'll also dive into Lookup and Reference functions.

In this section you will learn how to input and use Excel formulas for various calculations, including basic operations like addition, subtraction, multiplication, division, and power. Discover the importance of using functions for clearer and more efficient calculations. Explore statistical functions like AVERAGE, MEDIAN, MODE, MIN, and MAX to analyze data effectively.

In this section you will learn about array formulas in Excel and how they enable multiple calculations on sets of values simultaneously and how to use specific functions like UNIQUE, SORT, FILTER, and TRANSPOSE.

In this section, you will learn about lookup and reference formulas in Excel. These formulas enable you to search for and retrieve specific data from a table or range. You will explore essential functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP, which are invaluable for finding and referencing data efficiently.


array	The range or array to sort.
[sort_index]	(Optional) The column or row to sort by. The default is the first column or row.
[sort_order]	(Optional) A number indicating the desired sort order; 1 for ascending (default) or -1 for descending.
[by_col]	(Optional) A logical value indicating the direction of the sort; FALSE to sort by row (default) or TRUE to sort by column.

Excel Formulas

SORT