Challenge: Return the rightmost 12 values (rolling 12 months)
Hi,
Let's say there's a worksheet with the following headers:
Jan 2005 Feb 2005 .... Dec 2012
Cells below this are completed up to the current month.
I need to chart the most recent 12 months and have this move on
automatically as more months get added.
To do this, I'll have the months numbered 1 to 12 as headings, where 12 is
the most recently completed month (rightmost), 11 is the one before that and
so on, so 1 is a year ago.
Hope this makes sense.
Any way, how on earth would I go about this? Ideally the answer will be
formula driven...
Cheers,
Tom.
|