Skip to Main Content
Microsoft Excel 365 Bible
book

Microsoft Excel 365 Bible

by Michael Alexander, Dick Kusleika
March 2022
Beginner to intermediate content levelBeginner to intermediate
1072 pages
28h 16m
English
Wiley
Content preview from Microsoft Excel 365 Bible

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119835103Purchase Link