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. Jutaku

    Jutaku New 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....

    Please help!!

    Sincerly,
    A frustrated excel user:(

    Attached Files:

  2. Logit

    Logit Member

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

    Attached Files:

  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,318
    I'd rearrange my data then apply a simple formula
    upload_2017-5-20_11-42-44.png

    see attached file:

    Attached Files:

  4. bosco_yip

    bosco_yip Well-Known Member

    Messages:
    970
    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:

    Last edited: May 20, 2017 at 9:59 AM

Share This Page