Excel Video 349 has a practical example of using constants in an array formula. The example is a weighted average of the past 5 years of revenues. Notice how much space on the Excel spreadsheet it takes to do the weighted average compared to what can be done in one cell with an array formula.
We can simplify this example a little more. We’ll use named ranges with arrays in the next Excel Video. I look forward to seeing you then.
