Abstract
The introduction of dynamic array formulas in Excel is one of the greatest updates in Excel history. It completely changes the way that we think and write our formulas in Excel. New functions were introduced to harness the power of arrays, but this fundamental change in the engine increased the power of existing functions such as SUM, IF and TRANSPOSE too.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2022 The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature
About this chapter
Cite this chapter
Murray, A. (2022). Dynamic Array Formulas. In: Advanced Excel Formulas. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-7125-4_10
Download citation
DOI: https://doi.org/10.1007/978-1-4842-7125-4_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-7124-7
Online ISBN: 978-1-4842-7125-4
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)