How to Use the Microsoft Excel SORT Function

Configurare noua (How To)


While Microsoft Excel offers a built-in tool for sorting your data, you may prefer the flexibility of a function and formula. We’ll show you how to use the Excel SORT function with helpful examples. The benefit of using the SORT function is that you can sort the data in a different spot. If you want to manipulate the items without disturbing the original data set, you’ll like the sorting function in Excel.


Pasi de urmat
About the Excel SORT Formula

The syntax for the Excel sort formula is SORT(range, index, order, by_column) where only the first argument is required.

If you’re interested in using the optional arguments, here’s how they work:

  • Index: Enter a number to represent the row or column to sort by. Excel sorts by row 1 and column 1 by default.
  • Order: Enter 1 for ascending order which is the default if omitted, or -1 for descending order.
  • By_column: Enter False to sort by row, which is the default if omitted, or True to sort by column. This determines the direction of the sort.

Now, let’s look at examples using the SORT function in Excel.

Use the Excel SORT Function

You can use the SORT function for a range or array in Excel. Again, this does not sort your items in place but in the spot where you enter the formula.

For a basic example, we’ll simply sort the items in cells A2 through A6 using the defaults for the optional arguments:


SORT function for a single cell range

To sort a wider range, we’ll include the cells B2 through B6 as well:

As you can see, the items remain coupled with their attributes.SORT function for a larger cell range

Now we’ll sort our range by the second column rather than the first. So, we enter 2 for the index argument:


 You can see that our items are sorted in ascending order by the second column, 
with Green first and Yellow last.
SORT function using the second column

 Next, we’ll use an example with the order argument and sort our array in descending order by including -1:

Notice that we leave the index argument empty because Excel uses the first row and column by default. As intended, we have Tangerine first and Apple last.

SORT function for descending order

To sort in descending order by the second column, you’d use this formula:

=SORT(A2:B6,2,-1) Here, we include a 2 for the index argument and a -1 for the order argument. As expected, we see Yellow first and Green last.

SORT function for descending order in the second column

For one final example, we’ll include a value for each argument so you can see how they all work together. We’ll enter a larger array of A2 through C6, a 3 to sort by the third column, a 1 for ascending order, and False for sorting by row direction.

=SORT(A2:C6,3,1,FALSE) Our items are sorted by the Rating column and, like the other examples above, stay with their attributes.

SORT function formula using all arguments

By using the Excel SORT formula, you can get a different view of your data based on the order you want to see your items. This makes it a handy data analysis tool.

Tip solutie



(1 din 1 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?