March 2022
Beginner to intermediate
1072 pages
28h 16m
English
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.