Forecast based on latest 26 weeks data

G

Graham Tritton

I am trying to create a weekly forecast (for the future 26 weeks) of sales
units based on the last 26 weeks of sales performance. This forecast (linear)
is updated on a weekly basis as the weeks sales come in as well as the
"last_valid_week" named range. I can not get the starting point of the offset
function to work correctly. Here is a sample of my formula(that doesn't work).

=FORECAST(BL$3,OFFSET(ADDRESS(ROW(),MATCH(Last_valid_Week,3:3,),1,,"sheet1"),0,0,1,-26),OFFSET(ADDRESS(3,MATCH(Last_valid_Week,3:3,),1,,"sheet1"),0,0,1,-26))
Row 3 contains the date values and the equivalent row number(Sheet1) to the
current row(Forecast sheet) contains the sales data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top