+ Reply to Thread
Results 1 to 3 of 3

Assign random number (RANDBETWEEN) equal number of times

  1. #1
    Registered User
    Join Date
    05-26-2016
    Location
    Netherlands
    MS-Off Ver
    2007
    Posts
    13

    Assign random number (RANDBETWEEN) equal number of times

    Okay, so I have the following:


    Week Task Name
    week1 TaskA
    week1 TaskB
    week1 TaskC
    week1 TaskD
    week2 TaskA
    week2 TaskB
    week2 TaskC
    week2 TaskD

    I want to randomly assign names to a task. I have a group of names, each name has its own number. So now I can use RANDBETWEEN to randomly assign someone to a task. However, I want everyone to be assigned to an equal amount of tasks, I don't want person A do be assigned 5 times and person B 1 time. How can I ensure that each random number gets assigned an equal amount of times?

    Edit: Also, the random number has to be fixed. It's no use when one day Task A has to be done by Joe, and the next day by Mark.
    Last edited by dechesne; 12-20-2016 at 11:19 AM.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Assign random number (RANDBETWEEN) equal number of times

    The easiest way is to create a list of all the people and multiply it so you just have more (or the same) people as tasks. Add a rand function to the side of each person and sort by this.

    Regards

    Dav

  3. #3
    Registered User
    Join Date
    05-26-2016
    Location
    Netherlands
    MS-Off Ver
    2007
    Posts
    13

    Re: Assign random number (RANDBETWEEN) equal number of times

    Yes, however, this will make the report unflexible. When the report changes (people, weeks or tasks) I want it to work without manual intervention.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-20-2015, 03:10 PM
  2. Count how many times a number apears in random cells
    By ian.seethal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2014, 06:52 AM
  3. [SOLVED] Outputting number of times if a number is equal to or greater than
    By mnarvaez99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-11-2014, 10:51 AM
  4. Assign random number for a lottery
    By Alibuchan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-11-2013, 10:35 PM
  5. Randbetween or Random Number (1,3)
    By itselflearn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2013, 02:34 PM
  6. [SOLVED] VBA loop to copy a worksheet a number of times, assign name each time based on loop number
    By TBG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2012, 10:54 PM
  7. Random Number not more than 4 times
    By Ada01 in forum Excel General
    Replies: 2
    Last Post: 05-28-2009, 11:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1