CHAPTER 10Understanding and Using Array Formulas

The ability to work with arrays is one of Excel's most powerful features. Unlike standard formulas where a single formula results in a single answer, array formulas can return a series of answers to a series of cells on your worksheet. While array formulas have always been part of Excel, Microsoft has introduced dynamic arrays, paving the way for a paradigm shift in how we leverage the power of array formulas.

In this chapter, you'll first be introduced to the concept of arrays and get a foundational understanding of how the old legacy array formulas work. Then you'll explore Excel's exciting new dynamic array functions and discover some of the ways these new functions can help you go far beyond the capabilities of traditional formulas.

Get Microsoft Excel 365 Bible 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.