Sorting with Dynamic Arrays

February 21, 2022 - by Bill Jelen

Problem: Is there a simpler way to sort with a formula?

Solution: Yes, if you subscribe to Office 365 and have access to Dynamic Arrays. As I am writing this (April 2019), Dynamic Arrays are only in the Office Insiders channel.

Use =SORT(A2:B5,2,-1) to sort descending by the second column.

If your copy of Office 365 includes dynamic arrays, the entire discussion about ranking and using VLOOKUP to sort is simplified with a single SORT formula. — Figure 342. The new SORT function simplifies sorting with a formula

You can use SORTBY if you want to return the names from column A sorted by the numbers in column B but you don't need to see the numbers in the results.

Or, to show the people sorted without the scores, use =SORTBY — Figure 343. The SORTBY function returns sorted names.

This article is an excerpt from Power Excel With MrExcel

Title photo by Virginie-Sankara on Unsplash