• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Spread Value over Period with formula

Hannes M

New Member
Hi

I am trying to find a solution that would save a lot of input time within my company. We receive forecast from our customers. As it is now we manually input all the values accross time (months) and distribute the values equally. f.e. Customer forecasts to buy 10.000 units of Item 1 and the start month is Jan 2015 and length of period is 5 months. Then we set value 2000 for jan - may 2015. I would like just put in the total value, start month and number of months and it would spread equally between months and start with given start month. Any Ideas???

Best Regards
Hannes Már
 

Attachments

Back
Top