Randomly assigning employees to different groups

1. 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. Re: Randomly assigning employees to different groups

.
Here are two examples :

``Please Login or Register  to view this content.``

3. Re: Randomly assigning employees to different groups

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.

4. Re: Randomly assigning employees to different groups

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

5. Re: Randomly assigning employees to different groups

.
You are welcome.

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