More Arrays: Introducing Array Constants In Excel

Array constants are a component of array formulas. You create array constants by entering a list of items and then manually surrounding the list with braces ({ }). This paper explains how to use a component of array formulas called array constants: arrays that Excel stores and uses in memory instead of in a workbook. You create and use array constants whenever you need to add sets of values that don't change (such as month names or pi) to your array formulas. Constants process faster because they reside in memory. They also reduce clutter in your workbooks because, well, they reside in memory.