I have 60 students from 34 schools and i want to create 10 random groups of 6 students.
My big problem is that students from same schools should not exist in the same group.
I'm attaching the file.
Can anybody help me with this?
I have 60 students from 34 schools and i want to create 10 random groups of 6 students.
My big problem is that students from same schools should not exist in the same group.
I'm attaching the file.
Can anybody help me with this?
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks a lot AlphaFrog for your reply.
Although it creates 10 groups of 6 students each, there are cases where students from the same school exist in a group.
In the attached file i've highlighted them with yellow.
Have you any idea what we should change in the code in order to solve this problem?
Try this. Click on button to assign students.
Selecting a student's name on the left list will also highlight the teams for better visualizing.
多么想要告诉你 我好喜欢你
Fixed.
Please Login or Register to view this content.
Thanks a lot both of you. Both solutions worked.
You are great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks