Could you please attach your sample data as twbx format.
The calculation works as such:
I'm taking the first three departments and finding out their weighting:
500+700+500 = 1700 which gives a weightings of 500/1700 = .294118 700/1700 = .411765
Then I take Department 4 and allocate it into the other 3 as based on that pro rata weighting
Dept 1 = 500 + (-100*.294118) = 470.59
Dept 2 = 700 + (-100*.411765) = 658.82
Dept 3 = 500 + (-100*.294118) = 470.59
Basically, all of these departments are the sum of a number of months and then are being allocated a general overhead portion from an overseeing group from the same period of time.
Hopefully that clarifys
I'll see if I can sterilize some here today to do that Shin. Thank you.
This is a great step. And I think applying it to my workbook with a couple tweaks might do it perfect for me here.
You are very welcome.