Pinterest Pixel

SORT Formula in Excel

Bryan
 .
SORT Formula in Excel | MyExcelOnline SORT Formula in Excel | MyExcelOnline

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

Download excel workbookSORT-FORMULA.xlsx

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

=SORT(

SORT Formula in Excel

 

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 Formula in Excel

[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 Formula in Excel

[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)

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

 

If you like this Excel tip, please share it
SORT Formula in Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  5 Best Ways to Use Excel’s IF Function with Multiple Conditions

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...