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.

How To Assign Shift Randomly?

Discussion in 'Ask an Excel Question' started by Kenshin, Jun 18, 2017.

  1. Kenshin

    Kenshin Member

    Messages:
    51
    Hello guys it is nice see you again, i have a problem and need a hand here, please see the attach file

    thank you

    Attached Files:

  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    15,112
    Hi ,

    What is meant by evenly ?

    Narayan
  3. bosco_yip

    bosco_yip Well-Known Member

    Messages:
    1,168
    See attached file with helper formula way.

    Press F9 for re-calculation.

    Regards
    Bosco

    Attached Files:

    Last edited: Jun 18, 2017
  4. Kenshin

    Kenshin Member

    Messages:
    51
    Thanks Bosco appreciate, but how if i add up some more tables, i try the formula but no luck


    thank you

    Attached Files:

  5. bosco_yip

    bosco_yip Well-Known Member

    Messages:
    1,168
    1] Try to setup a 6 x 25 random number list for 6 tables and define names.

    2] See attached file

    Regards
    Bosco

    Attached Files:

    Thomas Kuriakose likes this.
  6. Kenshin

    Kenshin Member

    Messages:
    51
    Thank you Bosco, I'm humbled of your knowledge sir....

    regards
    Kenshin

Share This Page