Chapter 12
Dynamic array formulas and names in Excel
Using dynamic array functions to return many results
Using power formula techniques
Using dynamic array functions to return many results
Excel dynamic array formulas are entered in a single cell but return a large range of answers. This is much easier than the old array formulas. You won’t have to remember Ctrl+Shift+Enter anymore to use an Array formula. They debuted just after Excel 2019 shipped. People using Microsoft 365 have had access to them, but Excel 2019 did not support them.
The dynamic array functions are FILTER, RANDARRAY, SEQUENCE, SORT, SORTBY, and UNIQUE. Any functions introduced after the dynamic arrays can natively work with arrays. For example, see XLOOKUP in Chapter ...
Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) 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.
