Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Challenge: Return the rightmost 12 values (rolling 12 months)
Hi,
You can use the OFFSET function. This will show you the technique for rows. Just swap row and column information for your example. http://peltiertech.com/Excel/Charts/DynamicLast12.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Challenge: Return the rightmost 12 values (rolling 12 months)
That's genius!
Thanks! Tom. "Andy Pope" wrote: Hi, You can use the OFFSET function. This will show you the technique for rows. Just swap row and column information for your example. http://peltiertech.com/Excel/Charts/DynamicLast12.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need help with a formula for rolling twelve months | Excel Discussion (Misc queries) | |||
ROLLING 12 MONTHS PLEASE HELP ME!!!!! | Excel Discussion (Misc queries) | |||
Formula ? Return value from rightmost non-blank cell in a row of | Excel Worksheet Functions | |||
rolling 12 months | Excel Worksheet Functions | |||
rolling months | Excel Discussion (Misc queries) |