It’s my first time posting to MrExcel although I’ve been using your forum to teach myself the program for the past year! I can’t say enough how awesome and helpful this community is!
I have a list of 63 names that I need to sort into 9 groups of 7. This step is easy enough – however – I would like to do this a total of 3 times, where none of the group members are repeated. I.e., no two individuals are ever in the same group for three iterations (if it’s helpful, these represent 3 breakout sessions where people should be meeting 7 completely new people each time).
I have tried a variety of rand and randbetween formulas to no avail, as I can’t figure out how to set my formula so that each random integer between 1 and 9 is only repeated 7 times. I’m thinking you must need a VBA code and would truly appreciate anyone’s help -- I am a bit of a macro novice!! For simplicity you could call each name by a letter (A, B, C … AB, AC) and then the groups by integer. Or maybe not. That’s just my thinking so far.
I have tried to find a solution for this within the forums but have had no luck thus far.
THANK YOU!! I attribute ALL my Excel knowledge to MrExcel!!
-KateyM
I have a list of 63 names that I need to sort into 9 groups of 7. This step is easy enough – however – I would like to do this a total of 3 times, where none of the group members are repeated. I.e., no two individuals are ever in the same group for three iterations (if it’s helpful, these represent 3 breakout sessions where people should be meeting 7 completely new people each time).
I have tried a variety of rand and randbetween formulas to no avail, as I can’t figure out how to set my formula so that each random integer between 1 and 9 is only repeated 7 times. I’m thinking you must need a VBA code and would truly appreciate anyone’s help -- I am a bit of a macro novice!! For simplicity you could call each name by a letter (A, B, C … AB, AC) and then the groups by integer. Or maybe not. That’s just my thinking so far.
I have tried to find a solution for this within the forums but have had no luck thus far.
THANK YOU!! I attribute ALL my Excel knowledge to MrExcel!!
-KateyM
