How To Use the SORT Function—Easy Tutorial

Date:2022-4-28 Author:Sandra

Today, we are going to learn the usage of the SORT function. The SORT function can help us to sort the rows and columns in a data range. Now, let’s check this out.

Syntax:

=SORT(array,[sort-index],[sort-order], [by_col]

Array: The range of cells that is to be sorted. (Required)

[sort-index]: The number of the specific row or column according to which you want to sort the table. (Optional; Default is 1)

[sort-order]: An integer denoting whether to be sorted in ascending order or descending order.

-1 represents descending order; 1 represents ascending order. (Optional; Default is 1)

[by_col]: A Boolean value indicating whether to be sorted through tows or columns. (Optional; Default is FALSE.)

Now, let’s take an example to have a better understanding.

Here is the sale table out of order.

How To Use the SORT Function---Easy Tutorial

We enter =SORT(A2:C20,3,-1) in cell E2 and press Enter key.

How To Use the SORT Function---Easy Tutorial
How To Use the SORT Function---Easy Tutorial
How To Use the SORT Function---Easy Tutorial

Now we get a new table in descending order.

If we change the 1 into -1, we’ll get a new table in ascending order.

How To Use the SORT Function---Easy Tutorial
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *