© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. I. KatzUp Up and Array!https://doi.org/10.1007/978-1-4842-8966-2_6

6. SORT and SORTBY: The ABCs (and the CBAs)

Abbott Ira Katz1  
(1)
Edgware, UK
 

Sorting is one of those go-to spreadsheet ingredients that get tossed into data concoctions all the time. And the tossing has gotten easier across the generations, too. You may not remember the Paleotlithic sorts availing in the early generations of Lotus 1-2-3, in which users had to select the entire dataset to be sorted before going ahead; but then again, you don’t have to.

But you’ll certainly want to learn, and remember, the new dynamic array takes on sorting promoted by a pair of functions, SORT and SORTBY ...

Get Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.