Splitting a volume between cells without fractions/decimals

[xDav3yRox]

Hi,

I am looking to split a volume between multiple cells but keeping whole numbers.
For example, I need to split 10 units across 3 cells. But rather than 3.3, i would like it to split this to be 4, 3, 3

Any help would be appreciated if this is even possible!

 

[xDav3yRox]

Try = COUNTIFS($A$1:$A2, A2, $B$1:$B2, B2) instead of the ROWS()

Thank mike!

Does exactly what I needed it to. Thanks for your time and patience!