D
dhstein
I have some formulas that average the last 12 months of data. As new data
comes in the formula changes to reflect the change in the range. This all
works. The question is - am I doing it the "Best" way ? I figure out what
column I need to start with and what column I need to end with and I build a
string for the range then use the Indirect function. As I said, it works,
but I'm wondering if there is a simpler approach. As an additional twist,
besides the last 12 months I do the last 6 months and the last 3 months and
the same formula works for all 3 - by just pointing to a cell which contains
the number of months. Thanks for any help on this.
comes in the formula changes to reflect the change in the range. This all
works. The question is - am I doing it the "Best" way ? I figure out what
column I need to start with and what column I need to end with and I build a
string for the range then use the Indirect function. As I said, it works,
but I'm wondering if there is a simpler approach. As an additional twist,
besides the last 12 months I do the last 6 months and the last 3 months and
the same formula works for all 3 - by just pointing to a cell which contains
the number of months. Thanks for any help on this.