Chapter 36

Excel’s new dynamic array functions

Question answered in this chapter:

  • How does the UNIQUE function return a list of unique values from a list or range?

  • How can I use the SORT and SORTBY functions to create formulas to sort data?

  • How can I use the FILTER function to create formulas that filter data?

  • How can I use the SEQUENCE function to generate a list of sequential numbers in an array?

Chapter 35, “Array formulas and functions,” introduced you to array formulas and functions that were considered state of the art even before Office 365. This chapter discusses five amazing new dynamic array functions: UNIQUE, SORT, SORTBY, FILTER, and SEQUENCE. (The RANDARRAY function is discussed in Chapter 79, “Introduction to Monte Carlo simulation ...

Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition 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.

Start your free trial