Thebatfink
Active Member
- Joined
- Apr 8, 2007
- Messages
- 410
Hi,
I'm trying to get an offset formula to do the following..
Return me the range $A$5:LASTOCCUPIEDCELLINCOLUMN - 52 cells up.
So I basically end up with a range of the last 52 occupied cells in A:A.
I want this for a dynamic chart with a 12 month rolling update. I know this is available http://peltiertech.com/Excel/Charts/DynamicLast12.html but I'm struggling to modify it to my needs.
Any help would be greatly appreciated.
Thanks
Batfink!
I'm trying to get an offset formula to do the following..
Return me the range $A$5:LASTOCCUPIEDCELLINCOLUMN - 52 cells up.
So I basically end up with a range of the last 52 occupied cells in A:A.
I want this for a dynamic chart with a 12 month rolling update. I know this is available http://peltiertech.com/Excel/Charts/DynamicLast12.html but I'm struggling to modify it to my needs.
Any help would be greatly appreciated.
Thanks
Batfink!