Home |
Search |
Today's Posts |
#1
|
|||
|
|||
An OFFSET question
OFFSET's 1st argument is Reference my q is how do I get
reference to increment. To put it another way. Say I have 12 months data. Next month I add that month in so I now have 13 months data, but how do get OFFSET to drop the 1st month so that I only view the last 12 months? TIA johnb |
#2
|
|||
|
|||
Hi
maybe something like ´SUM(OFFSET($A$1,COUNTA(A:A)-1,-12,1)) -- Regards Frank Kabel Frankfurt, Germany "johnb" schrieb im Newsbeitrag ... OFFSET's 1st argument is Reference my q is how do I get reference to increment. To put it another way. Say I have 12 months data. Next month I add that month in so I now have 13 months data, but how do get OFFSET to drop the 1st month so that I only view the last 12 months? TIA johnb |
#3
|
|||
|
|||
Hi John,
How about =SUM(OFFSET(N1,0,-12,1,12)) -- HTH RP (remove nothere from the email address if mailing direct) "johnb" wrote in message ... OFFSET's 1st argument is Reference my q is how do I get reference to increment. To put it another way. Say I have 12 months data. Next month I add that month in so I now have 13 months data, but how do get OFFSET to drop the 1st month so that I only view the last 12 months? TIA johnb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OFFSET and array formulae | Excel Discussion (Misc queries) | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions | |||
Passing Cell Address to Offset | Excel Worksheet Functions | |||
Offset? | Excel Discussion (Misc queries) | |||
sum offset question | Excel Worksheet Functions |