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
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.
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
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!
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.
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
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")
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??
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?
Hello, Wondering if you have any # of people, odd or even, how this would work? For example, say you have 21 couples, 2 singles and wanting to group the lot so that there are 6 people to a monthly dinner party group, each month having different couples, adding the 2 singles randomly each time to different groups? Thank you in advance for this great video and help. :)
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.
Hi there. Completely off topic, but I'm wondering if there's a way to receive a pop up notification with editable content once a set of circumstances have been reached and also a pop up to notify the user that x amount of days have elapsed since a time stamp was entered. Thanks in advance for your reply.
Sure, this would require some VBA though. We could have a Message Box or custom Userform pop up for whatever conditions we desire. It could contain the number of days and even fields for editing. No problem. It is not a task that can be explained in detail in a comment though and would require VBA.
You would need to calculate the 4 if it is not inputted into the formula or cell directly, because in this instance because I have 3 groups there will be 4 in each. You could have a cell where someone/you specifies how many groups there are (3 in this example). Then a different cell with a formula that divides the total names by the cell containing the number of groups. This calculates how many names would need to be in each group. You can then reference this in the formula.
This error indicates an issue with commas or brackets typically. Maybe you closed a bracket too early, or missed a comma. This is because the commas separate the arguments, and the brackets enclose them. I hope you fix it 😊
The arguments are the options between the brackets and separated by commas. This error would indicate that you have either missed a comma, or missed a question/option/argument.
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?
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
Another great video.......I particularly like the paste values trick!
Thank you Kevin.
Solid. Thank you!
Thanks Craig
Can you take a list of names from a column and randomize just the names ?
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?
Simple, Easy to understand and very informative video! Good Job Sir!
Thank you Tobi.
This really helped, I'm on my way. Thanks for helping!
Glad to hear it! You're welcome, Kristine.
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.
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
Awesome video, thank you!
You're welcome. Thank you, Ivey.
Thanks for this video! It's really helpful. Is it possible to move the groups into their own tabs?
They would need to be moved after. Power Query or macros would offer that functionality.
Thanks a lot sir
You're welcome. Thank you.
Really helpful dude... thanks lot
You're very welcome 👍
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!
Hey..did you get solution to this?
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.
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
Hello sir very helpful video.
Please make a video of full ASAP Utilities tutorial.
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")
Thanks, Michael. Sure, you could do that.
Is there a way to do this but multiple times and ensuring that easy name is evenly assign to the three different groups?
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??
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?
Is this a simple randomization?
Thank you so much.
Can i use this way for randomized clinical trial study?
Sure. Random selection is random selection.
Sir how can I specify specific numbers for names to come randomly
Hello, Wondering if you have any # of people, odd or even, how this would work? For example, say you have 21 couples, 2 singles and wanting to group the lot so that there are 6 people to a monthly dinner party group, each month having different couples, adding the 2 singles randomly each time to different groups? Thank you in advance for this great video and help. :)
Did you ever get your answer?
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.
Hi there. Completely off topic, but I'm wondering if there's a way to receive a pop up notification with editable content once a set of circumstances have been reached and also a pop up to notify the user that x amount of days have elapsed since a time stamp was entered. Thanks in advance for your reply.
Sure, this would require some VBA though. We could have a Message Box or custom Userform pop up for whatever conditions we desire. It could contain the number of days and even fields for editing. No problem.
It is not a task that can be explained in detail in a comment though and would require VBA.
Thank you, kindly. What are the chances of a tutorial on that coming our way anytime soon? Just asking, of course :-)
How to do this if we have a large dataset ,say 1000
i m wondering how can we divide number dynamically instead of 4 or any other number?....
Sure you could reference a cell containing the number, instead of hardcoding the 4 into the formula.
but i am asking how can we equally split colours name without using 4 or any other numbers dynamically...
You would need to calculate the 4 if it is not inputted into the formula or cell directly, because in this instance because I have 3 groups there will be 4 in each.
You could have a cell where someone/you specifies how many groups there are (3 in this example). Then a different cell with a formula that divides the total names by the cell containing the number of groups. This calculates how many names would need to be in each group. You can then reference this in the formula.
ok thanks for your answer....
No problem Haider. Thank you for the comments.
Please group name aed
Hi, can you help me for prizebond lucky number in pakistan?
And we divide them red blue in 70:30 ratio
How did u: "make that absolute"?
You can press the function key F4 when your insertion point is on the reference you want to make absolute.
Hello plz reply can do or not plz
so this is random sampling
not random assignment ?
They are being assigned to groups
I keep getting a message that say “I’ve entered too few arguments for this function”
This error indicates an issue with commas or brackets typically. Maybe you closed a bracket too early, or missed a comma.
This is because the commas separate the arguments, and the brackets enclose them.
I hope you fix it 😊
Jesus Loves You
Bro It`s Showing Me You Have Entered Too Few Argument
The arguments are the options between the brackets and separated by commas. This error would indicate that you have either missed a comma, or missed a question/option/argument.