Inside Microsoft Excel

Use array constants to store static values so you can save time-and sanity!

Inside Microsoft Excel

by Kara Hiltz

Arrays are a staple for any Excel power user. The simple processes of opening, closing and calculating the workbook’s formulas can take much longer than necessary if you aren’t using arrays to streamline. You can use arrays to designate groups of constants – that is, static values that won’t change, such as tax rates or interest percentages. This is useful if you want to use these static values in a formula – since they[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)