Hello Excel Forum - 1st time poster so please go easy, but hopefully this is quick one for someone to solve
I am trying to create an offset of table data for a rolling 13 week chart, but am finding the following formula is leaving me with a blank cell at the end of the offset:
=OFFSET(PAST_DUE_SUMMARY[Percentage Past Due],COUNT(PAST_DUE_SUMMARY[Percentage Past Due]),0,-14,1)
Any ideas?
offset.PNG
It would be easier with a sample sheet.... Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
Hi Alex,
Have you looked at using a Dynamic Named Range? If you post an example file, it would much easier to help with your problem like Glenn suggested above...
https://www.ozgrid.com/Excel/DynamicRanges.htm
http://www.exceluser.com/formulas/dynname1.htm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks