© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. I. KatzUp Up and Array!https://doi.org/10.1007/978-1-4842-8966-2_1

1. What’s an Array, Anyway?

Abbott Ira Katz1  
(1)
Edgware, UK
 

Good question. That term – array – has secured a foothold in all sorts of computing vocabularies and has made a series of guest appearances in the dictionaries of other scientific domains as well. But while that’s all very nice, you want to know what arrays mean for the Excel user, and how that understanding can add value – quite a bit of value – to your work with spreadsheets.

A Working Definition

Defining spreadsheet arrays is an assignment that brings with it bad news and good news. The bad news is that definitions of spreadsheet ...

Get Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond 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.