Formula Needed for- Adding data from one cell into another

[blue84rain]

Hi,

I need to create a formula based on the data in column E and put the new information in column F. The "Orders" from E have to be Dividable by the "Size" in D.
ex: E2 (3) /D2 (1) = 3 (Divides Evenly, so it stays) (New order amount (3), Column F)

BUT if it can't then the extra amount would have to be added to the lower sub-group
ex: E38 (7) / D38 (5) doesn't divide evenly, so 5 of the 7 has to stay while the remainder 2 has to be added into the E2 amount, since the date and Group have to remain constant. Meaning Group AAA's data can only be moved within

Template01.xlsx

[azumi]

Not sure:

=IF(MOD(E2;D2)=0;"";E2/D2+MOD(E2;D2))

[blue84rain]

It didn't end up working for me. Were you able to get it to work on the file that is attached? Thanks for helping out btw!