What does it do?

Sorts a table based on a column and order specified

Formula breakdown:

=SORT(array, [sort_index], [sort_order])

What it means:

=SORT(data to be sorted, [which column to be used for sorting], [ascending or descending order])

Did you know that you can now sort your table data with an Excel Formula? Yes you can! It is definitely possible now withÂ Excel’s SORT Formula. It is a new formula introduced in Office 365 released in 2018!

We have a tax table that we want to sort by the tax rate in aÂ descending order.

I explain how you can do this below:

STEP 1: We need to enter the SORTÂ function in a blank cell:

## =SORT(

STEP 2:Â The SORTÂ arguments:

## array

What is the data to be sorted?

Select the cells containing the tax data, do not include the headers:

## [sort_index]

What is the column to be used for sorting?

We specify the column number here. Since the tax rate column is the second column, place in 2.

## [sort_order]

What is the sort order? 1 for Ascending, -1 for Descending order.

Since we want descending order, place in -1.

## =SORT(C9:D14, 2, -1)

Now it gets sorted magically!

How to Use the SORT Formula in Excel

If you like this Excel tip, please share it

email

Pinterest