1. ### Welcome to Chandoo.org Forums. Short message for you

Hi Guest,

Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

Yours,
Chandoo
2. Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...

3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

# Been trying to evenly distribute numbers

Discussion in 'Ask an Excel Question' started by Jutaku, May 19, 2017.

1. ### JutakuNew Member

Messages:
1
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....

Sincerly,
A frustrated excel user

File size:
11.7 KB
Views:
5
2. ### LogitActive Member

Messages:
100
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.

File size:
12.2 KB
Views:
2
3. ### HuiExcel NinjaStaff Member

Messages:
10,606
I'd rearrange my data then apply a simple formula

see attached file:

File size:
11.8 KB
Views:
4
4. ### bosco_yipWell-Known Member

Messages:
1,223
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

#### Attached Files:

• ###### Distribute numbers evenly.xlsx
File size:
12.7 KB
Views:
4
Last edited: May 20, 2017