Been trying to evenly distribute numbers

[Jutaku]

Good Day Everyone,
I have been trying all day to figure out what I need to do in order to evenly (+1; -1) across 15 columns. I have tried randbetween, but to no avail it hasn't worked for me.
Attached is what I have been trying to work on, hope that you all can help.

Sample:
B4 has 345, but I want that distributed evenly (+ or - 1) across 15 columns such as E4, G4, I4 and so on....

Please help!!

Sincerly,
A frustrated excel user

 

[Logit]

I'm certain there is a faster way to accomplish the goal but here is what I did ...

In D4: =B4/15
In D5: =B5/15
In D6: =B6/15
In D7: =B6/15

Then I copied those formulas across to E, H, J, L, N, P, R, T, V X Z AB, AD, AF

Formatted each of those cells for NUMBER / NO DECIMALS.

This will result in a partial anatomical part 'hanging out there in the wind'. It's
decision time then what to do with the partial body part.

 

[Hui]

I'd rearrange my data then apply a simple formula


see attached file:

 

[bosco_yip]

Distribute numbers evenly :

1] Based on the OP's original layout and adopt Hui's idea.

2] In D4, formula copy down to D7 :

=INT($B4/15)+(15-MOD($B4,15)<COUNT($C$2:C$2))

3] Then, select D4:D7, Copy / Paste to F4:F7, H4:H7, J4:J7 and L4:L7…......

4] See attached file.

Regards
Bosco