+ Reply to Thread
Results 1 to 6 of 6

Random groups of students

  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    GREECE
    MS-Off Ver
    Excel 2010
    Posts
    9

    Random groups of students

    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?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Random groups of students

    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.

  3. #3
    Registered User
    Join Date
    01-15-2014
    Location
    GREECE
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Random groups of students

    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?
    Attached Files Attached Files

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Random groups of students

    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.
    Attached Files Attached Files
    多么想要告诉你 我好喜欢你

  5. #5
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Random groups of students

    Fixed.

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    01-15-2014
    Location
    GREECE
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Random groups of students

    Thanks a lot both of you. Both solutions worked.
    You are great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-11-2013, 10:52 AM
  2. [SOLVED] Pick a random person from a list of students
    By jmeddaugh in forum Excel General
    Replies: 15
    Last Post: 10-16-2013, 09:25 AM
  3. Mail merging students into separate groups
    By Cloudburst in forum Excel General
    Replies: 1
    Last Post: 08-28-2013, 11:21 AM
  4. Assigning Random Jobs To Students
    By costigan555 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2013, 01:22 PM
  5. Replies: 1
    Last Post: 10-27-2010, 02:01 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1