So many times I watch videos and I am still lost at the end. You are EXCELLENT at walking through the steps and explaining everything. For the first time EVER, I actually subscribed. You are my one and only! Thank you!
This is great but is there a way of doing this with unequal sized groups (the groups would be assigned as a percentage of the total number of participants - ie 30% in one group, 20% in another, etc)?
This is helpful. Chester, could you also help in case after the first grouping done, there is a need to have more rounds of similar groups, where pairing is to be done in a way that there are no duplicate pairings in any subsequent rounds. For eg, in your example, in first round of grouping, Jeri and Teofila have been paired. So in next round, these 2 should not be paired together and we get a new list of pairings with other names.
Thanks, Chester, very helpful. Amit - Yes, it's possible, just make two such tables as the author describes then do a joint lookup. I had a similar problem assigning groups of applicants to readers that you can adapt. In my case, it was scholarship applications. I had 50 applicants and 40 readers, and assigned each reader 5 applicants, so that each application is read by 4 readers, and no reader gets duplicate applicants. So I made two tables, each with the same numbers of groups, and then matched readers to applicants by group number. The Applicant table group size is based on division by 5 applications per reader, which gives 10 groups for 50 applicants. The Reader table group size is by division by 4 readers per applicant, giving 10 groups for 40 readers. Then I made a separate column of all the readers and their group numbers and used the Filter function to list all the applicants with matching group numbers, similarly to shown here but added the Transpose function to display them horizontally. If the numbers of applicants and readers are not evenly divisible, there will be leftovers, so just manually reassign a few to even it out. In your case, the total number of groups would be groups times rounds, so you'd need to individually identify them. E.g., Round 1-Group 1, 2, n to Round X-Group 1, 2,..n for X rounds of n groups. So if you have say 4 rounds of 10 groups, it’s the same problem I had. I can’t share a spreadsheet with PII but can give you redacted screenshots. No way to post them on a YT comment apparently…
Hi! I watched your video and it's great! I have an additional question though. Is it possible to make 4 different groups at the same time with the same people so that each person is in a group with different people each time?
Dear Mr. Tugwell, is there an option to do a covariate adative randomization in excel as well? Thank you so much for your explanation. It is very helpful.
great video for what I need to accomplish. However, how can I set this up to change the names in random groups for a 20 week workshop once through all participants before duplicating?
This is amazing thank you. Is there a way in which you can add a condition - so that the random groups are balanced according to, for instance, the skill rating 1-3 of each person?
Great tutorial. I was wondering if you can help with this request. I have a list of items (merchandise) along with their MSRP. I would like to group random items in groups such that the MSRP price of each group equals a value defined by myself. Is that possible?
Thank you for the video. is it possible to assign girls and guys to specific cells? I want to have a grouplist like 1- guy 2- girl 3- guy 4-girl 5-guy/girl
What I did was just place a new =RAND() formula in column C (whereas he copy-pasted it to have the values set). Every time I set a group size (even if I input a same numer), I'll get random groups.
This is great and helpful. But I would like to know how to take this a step further... I have 25 kids that need to be randomly assigned into 6 groups. (this video showed how to do this) But these kids will be together for 6 days and there will be a new group each day, with no two of the same kids ending up in the same group on the following five days. Help?
This is very similar to what I want to do, but not quite. What I’m looking to do is assign people to tables/groups with a certain number in each group. So, let’s say we have 10 tables with 8at each table. And I want some at every table, even if it’s not 8. If one table has 6 and another has 8, that’s okay. So if I only have 40 people, I still want some at each table. I know I can change the group size, but is there another way to do this? Also, can I add participants later?
Hi! This is great! How can i do it with more criteria? Lets say I want them to work in groups with team members they have not worked with before. An/or i want it to consider gender as well :)
What if you want to create groups of 4 across a group of names that changes each month. So across 6 months, I want 3 groups of 3 or 4 people (the group has 11 people). I want a different group of names each month until after 6 months, every person has been in a group with each of the other 10 members of the team.
This actually helped me on what I'm trying to do but I have repeat names. For example, I have I can have (2) Xuan Wilkey, (5) Winston Kell, and (10) Jeri Huls. I would like to pair them by groups of 2 along with the rest of the list but it would give me in a group for example two Winston Kell. It has to be a unique combination, no Winston-Winston or Winston-Xuan, Xuan-Winston. Any help would be much appreciated 😀
So many times I watch videos and I am still lost at the end. You are EXCELLENT at walking through the steps and explaining everything. For the first time EVER, I actually subscribed. You are my one and only! Thank you!
After so many searches got this video and its amazing.
Fantastic video! I love that I can do this and didn't have to export any data to another organization or website. Thanks so much!
Wow! This is truly cool. Although I don't think I can do it on my own without following your video. Thanks so much
Great video. Thanks
A very interesting working procedure Chester. Excellent video. Thank you.
Thank you so much for the tutorial! It is very helpful
This is great but is there a way of doing this with unequal sized groups (the groups would be assigned as a percentage of the total number of participants - ie 30% in one group, 20% in another, etc)?
This is helpful. Chester, could you also help in case after the first grouping done, there is a need to have more rounds of similar groups, where pairing is to be done in a way that there are no duplicate pairings in any subsequent rounds. For eg, in your example, in first round of grouping, Jeri and Teofila have been paired. So in next round, these 2 should not be paired together and we get a new list of pairings with other names.
Thanks, Chester, very helpful.
Amit - Yes, it's possible, just make two such tables as the author describes then do a joint lookup.
I had a similar problem assigning groups of applicants to readers that you can adapt.
In my case, it was scholarship applications. I had 50 applicants and 40 readers, and assigned each reader 5 applicants, so that each application is read by 4 readers, and no reader gets duplicate applicants. So I made two tables, each with the same numbers of groups, and then matched readers to applicants by group number.
The Applicant table group size is based on division by 5 applications per reader, which gives 10 groups for 50 applicants.
The Reader table group size is by division by 4 readers per applicant, giving 10 groups for 40 readers.
Then I made a separate column of all the readers and their group numbers and used the Filter function to list all the applicants with matching group numbers, similarly to shown here but added the Transpose function to display them horizontally.
If the numbers of applicants and readers are not evenly divisible, there will be leftovers, so just manually reassign a few to even it out.
In your case, the total number of groups would be groups times rounds, so you'd need to individually identify them. E.g., Round 1-Group 1, 2, n to Round X-Group 1, 2,..n for X rounds of n groups. So if you have say 4 rounds of 10 groups, it’s the same problem I had.
I can’t share a spreadsheet with PII but can give you redacted screenshots. No way to post them on a YT comment apparently…
This is exactly what I need to do as well.
Hi! I watched your video and it's great! I have an additional question though. Is it possible to make 4 different groups at the same time with the same people so that each person is in a group with different people each time?
Hi. I truly appreciate the video. I do however have a question. How can I make 10 groups where some names can appear twice?
Very helpful!!
Dear Mr. Tugwell,
is there an option to do a covariate adative randomization in excel as well?
Thank you so much for your explanation. It is very helpful.
Is it possible to do this, but with manually pairing people instead?
great video for what I need to accomplish. However, how can I set this up to change the names in random groups for a 20 week workshop once through all participants before duplicating?
Can this be done with a fixed number of groups, rather than group size?
This is amazing thank you. Is there a way in which you can add a condition - so that the random groups are balanced according to, for instance, the skill rating 1-3 of each person?
A very good video. How can i do a good mix of 9 boys and 7 girls with 4 groups (2 boys and 2 girls), 3 times without repeat ?
I have exactly the same question.🙏
Great tutorial. I was wondering if you can help with this request. I have a list of items (merchandise) along with their MSRP. I would like to group random items in groups such that the MSRP price of each group equals a value defined by myself. Is that possible?
Interesting concept and wonderfully executed. I wonder if this could be done in a single cell or a formula with the new dynamic of Ray’s
That was great. Thanks
Thank you for the video. is it possible to assign girls and guys to specific cells? I want to have a grouplist like 1- guy 2- girl 3- guy 4-girl 5-guy/girl
love this. Is there a way to then repeat it randomly?
What I did was just place a new =RAND() formula in column C (whereas he copy-pasted it to have the values set). Every time I set a group size (even if I input a same numer), I'll get random groups.
This is great and helpful. But I would like to know how to take this a step further...
I have 25 kids that need to be randomly assigned into 6 groups. (this video showed how to do this) But these kids will be together for 6 days and there will be a new group each day, with no two of the same kids ending up in the same group on the following five days.
Help?
Do you know how to then apply formula so that students won’t be in another group with the same people?
This is very similar to what I want to do, but not quite. What I’m looking to do is assign people to tables/groups with a certain number in each group. So, let’s say we have 10 tables with 8at each table. And I want some at every table, even if it’s not 8. If one table has 6 and another has 8, that’s okay. So if I only have 40 people, I still want some at each table. I know I can change the group size, but is there another way to do this? Also, can I add participants later?
awesome
Hi! This is great! How can i do it with more criteria? Lets say I want them to work in groups with team members they have not worked with before. An/or i want it to consider gender as well :)
What if you want to create groups of 4 across a group of names that changes each month. So across 6 months, I want 3 groups of 3 or 4 people (the group has 11 people). I want a different group of names each month until after 6 months, every person has been in a group with each of the other 10 members of the team.
Janice - see my reply to Amit above, similar solution - two tables.
I have a group of thirty people. However, my groups are not spread uqually. How can i solve this?
This actually helped me on what I'm trying to do but I have repeat names. For example, I have I can have (2) Xuan Wilkey, (5) Winston Kell, and (10) Jeri Huls. I would like to pair them by groups of 2 along with the rest of the list but it would give me in a group for example two Winston Kell. It has to be a unique combination, no Winston-Winston or Winston-Xuan, Xuan-Winston. Any help would be much appreciated 😀
Somehow I have managed to get this wrong and rand gave me date and time lol