What Is An Array
The term “array” comes from programming, but you’ll hear it come up often in the context of more advanced Excel formulas. What does it really mean? An array is a structure or container that holds a collection of items. For example, this array contains 3 items, the numbers 10, 20, and 30: {10,20,30} And this array contains three text strings: {“red”; “blue”; “green”} Note that arrays in Excel are always enclosed in curly braces....