Forum Discussion
Solved
Divide as Whole Number and Allocate to Monthly Column
I have a sheet with start date, finish date and quantity, then have a formula that divides the quantity over the selected months and enters the result into the appropriate month column. What I am...
Yes - see the attached workbook.
See the attached demo, with a formula that should work in all versions of Excel.
Hans Vogelaar,
That is fantastic, thank you.
Is there are way to reverse the increment?
To try and explain ....
In the monthly columns, Instead of 15 + 15 + 15 + 14 + 14 = 73
Can I get 14 + 14 + 15 + 15 + 15 = 73
That is fantastic, thank you.
Is there are way to reverse the increment?
To try and explain ....
In the monthly columns, Instead of 15 + 15 + 15 + 14 + 14 = 73
Can I get 14 + 14 + 15 + 15 + 15 = 73
Yes - see the attached workbook.
- Hans Vogelaar,,
Perfect, thanks for your help.
I would never have established how to do it without support.