Randomly Assign Names to Groups - Excel Formula

In this video, we look at randomly assigning names into three different groups using an Excel formula.

We look at 2 different examples of doing this. Firstly we quickly assigning twelve names into 3 different groups.

Then we look at evenly distributing the names into 3 groups ensuring there are 4 names in each.

The formulas to produce random numbers are volatile, so the video shows you a quick tip to convert formula to values also. And some other options.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[jonathanschmidt]

Can you take a list of names from a column and randomize just the names ?

[bobbinsnest]

Hi, great video. Can you please add to the formula "skill level". So when the teams are assigned, it's balanced on skill level too?

[dasdeke]

Very helpful for something I'm doing for work. One suggestion you could do if you want the values, verse the caluated values, is copying the column, then going to paste, and pasting as values

[reinarice]

Very help and would like to take it a step forward. How can I modify this so I can have 4 different groups and ensure each person gets each color. For example, Group1 is 8am with blue; Group2 is 9am with green; Group3 is 10 am with red, and Group4 is 11 am with yellow.

[Abzyoutbero]

Simple, Easy to understand and very informative video! Good Job Sir!

[kevinclifford]

Another great particularly like the paste values trick!

[Chattmandoo]

How do you take this name depending on colur and make 3 list with names.? Some kind of xlookup? But how do you do it?

[ryansmith]

Hey! Thanks for the video this really helps! Do you know of a way to add priorities to this? For example geoff and samantha have a higher chance to be in the red group

[kristineregehr]

This really helped, I'm on my way. Thanks for helping!

[siddi_q]

Great video! Is there a way to evenly distribute if you have an ODD number of candidates. Suppose I have 61 students and I want to distribute them as evenly as possible amongst 6 groups.

[caitlinhowe]

Thanks for this video! It's really helpful. Is it possible to move the groups into their own tabs?

[jeremyperalta]

Is there a way to do this but multiple times and ensuring that easy name is evenly assign to the three different groups?

[mlhess]

This is cool! Rather than having the RAND() function in a separate column, can you make it part of the formula? For example, ...CHOOSE(ROUNDUP(RANK(RAND(), $C$2:$C$13)/4, 0), "Red", "Blue", "Green")

[savvy_me]

Hello brother i want the people's names to be automatically entered in the right cell when i enter their number in the left cell so i don't have to type the name and number every time

[kerrygilbert]

I have tried using this method =RAND() and then =CHOOSE(ROUNDUP(RANK(D3, D3:D43)/10, 0), "Group 1", "Group 2", "Group 3", "Group 4") to make four groups of 10, but it has not given me 10 per group - can you see if I have made a mistake??

[dylanmaarse]

Very helpful video! However, I have another question, which is more difficult I believe. Is it possible to create a formula in Excel that distributes names to different groups just like in the video, but also can do this month after month with the same groups but that the names can't be in the same group together? For example, in month 1 group 1 consists of names A, B & C and there are 10 similar groups with 3 names (D, E, F etc.) and in month 2 you want to have different names in each group which haven't been paired up in month 1. Could you tell me whether this is possible and how to do that? Thanks in advance!

[kameshsharma]

Hello sir very helpful video.
Please make a video of full ASAP Utilities tutorial.

[JRod]

Is there a way to set different group sizes? For example, what if I wanted to have Group A with 12 peopele, Group B with 20, and Group C with 15 and Group D with 12? Or does that not work?

[NosaMandili]

Thank you so much.
Can i use this way for randomized clinical trial study?

[kesarb.k]

Dear Sir Ur all video very Very helpful but I have some problem VBA activex control cannot insert object excel 2007 can u help me plz. From dubai thank you.