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