Excel Sort With a Formula Using SORT and SORTBY
September 25, 2018 - by Bill Jelen
This week at the Ignite Conference in Orlando Florida, Microsoft debuted a series of new, easier array formulas in Excel. I will be covering these new formulas every day this week, but if you would like to read ahead:
- Monday covered the new =A2:A20 formula, the SPILL error, and the new SINGLE function required in place of Implicit Intersection
- Today will cover SORT and SORTBY
- Wednesday will cover FILTER
- Thursday will cover UNIQUE
- Friday will cover SEQUENCE and RANDARRAY functions
Sorting with a Formula in Excel used to require an insane combination of formulas. Take a look at this data which will be used throughout this article.
In order to sort this with a formula before this week, you would just have to knock out RANK, COUNTIF, MATCH, INDEX and INDEX. Once you finished this set of formulas, you would be ready for a nap.
Joe McDaid and his team have brought us SORT and SORTBY.
Let's start with SORT. Here is the syntax
=SORT(Array, [Sort Index], [Sort Order], [By Column])