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:

SORT Formula in Excel | MyExcelOnline


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


SORT Formula in Excel


STEP 2: The SORT arguments:


What is the data to be sorted?

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


SORT Formula in Excel


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(C9:D14, 2,

SORT Formula in Excel


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)

SORT Formula in Excel


Now it gets sorted magically!

SORT Formula in Excel


How to Use the SORT Formula in Excel


SORT Formula in Excel | MyExcelOnline



Click here to access these FREE Excel courses!

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn