Splashing the numbers based on past average
Good Day all,
I am trying to allocate the May projected cost (H2) into country level (H4:H16) based on the country average of last month actual (F4:F16).
The country average should be the same as Actual April for May. File attached for your easy reference.
Can anyone help me on this?
What do you mean by "splashing the numbers"? Explain your sample data and your expected results.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for your response and apologize for the confusion.
I mean H2 is my total projected cost for May. I would like to allocate this cost in to country level based on the April cost/box.
If I allocate this cost based on the May boxes, I am getting different cost/box for May.
Note : My idea is to keep the same April cost/box for all countries since I don't see any variations in the market condition.
If this means that the values in column I should be the same as the values in column F then try pasting the following into cell H4 and copying down: =G4*E4/D4The country average should be the same as Actual April for May.
If that doesn't produce the desired values, then it may help if you could tell us how you would fill column H manually, so that we can attempt to come up with a formula/code that will produce the same results.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks