+ Reply to Thread
Results 1 to 5 of 5

Randomly assigning employees to different groups

  1. #1
    Registered User
    Join Date
    10-18-2019
    Location
    PA
    MS-Off Ver
    MAC 2008
    Posts
    2

    Randomly assigning employees to different groups

    So im having trouble assigning employees to different departments at my work.

    Say theres 12 employees and 4 different departments (A,B,C,D).

    Some days 3 people are working in each department. Randomly assigning that would be easy. However, most days, department A only needs 2 people or department D needs 4. Some days one department wont be running at all.

    Ive been messing with Rand() roundbetween rank, but i cant seem to figure out how to do this with differing group sizes. Is there a way i can input how many people i need in each department and have it randomize the right number of employees for each department based on my necessity??

    Even a nudge in the right direction would be great. Im ignorant. Thanks in advance!

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,491

    Re: Randomly assigning employees to different groups

    .
    Here are two examples :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016
    Posts
    894

    Re: Randomly assigning employees to different groups

    Please review in this file.

    Formula description.

    Please Login or Register  to view this content.
    $G7 = Staff no in each department.
    $C$4:$C$15 = Range of staff name.
    $D$4:$D$15 = Range of random value.

    Regards.
    Attached Files Attached Files
    Last edited by menem; 10-20-2019 at 05:27 AM. Reason: Add code tags

  4. #4
    Registered User
    Join Date
    10-18-2019
    Location
    PA
    MS-Off Ver
    MAC 2008
    Posts
    2

    Re: Randomly assigning employees to different groups

    Awesome. Exactly what i was talking about. Thank you!

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,491

    Re: Randomly assigning employees to different groups

    .
    You are welcome.

+ 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. [SOLVED] VBA to randomly select 10 employees from a list of employees
    By Kimston in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 08-18-2018, 12:13 PM
  2. Replies: 8
    Last Post: 02-28-2018, 10:34 AM
  3. Help assigning reviewers to applications randomly
    By LCLEE00 in forum Excel General
    Replies: 3
    Last Post: 11-27-2017, 03:47 PM
  4. Assigning tasks to employees and moving between employees
    By sbo123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2014, 10:37 AM
  5. Ranking employees from different groups?
    By BitterGreg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2014, 11:54 AM
  6. Randomly Assigning Names
    By kevinclark100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2013, 03:36 PM
  7. Schduling Employees - Fairly - Randomly
    By nickmessick1 in forum Excel General
    Replies: 4
    Last Post: 06-18-2013, 02:47 PM

Tags for this Thread

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