What does it do?
Sorts a table based on a column and order specified
=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:
STEP 2: The SORT arguments:
Table of Contents
What is the data to be sorted?
Select the cells containing the tax data, do not include the headers:
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.
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