Today we’ll simplify the formula we created in Excel Video 349 by naming an array in Excel Video 350. If you’re going to reuse an array with constants, an easy way to do it is to name the array. Watch how I have to put braces around the array in the formula and how I still have to press ctrl+shift+enter when I used a named array in a formula.
Once I have a named array, I have an easy, consistent way to use the array in a variety of formulas. Since arrays have some syntax rules we have to follow, it’s easier to get the syntax right once, name the array, and then the only thing you have to remember is to press ctrl+shift+enter when using the named array in a variety of situations.
