+ Reply to Thread
Results 1 to 2 of 2

Moving student rows to respective subject sheets

  1. #1
    Registered User
    Join Date
    10-06-2012
    Location
    Trichy, India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Moving student rows to respective subject sheets

    I have a 600 hundred students and 10 classrooms. 10 different subjects are taught in 10 classrooms. Each class can have only 60 students. Each student can have 3 options, according to their percentage classrooms have to be allocated.

    I have a sheet having cells:

    Name Choice1 Choice2 Choice3 Percentage
    A subject1 subject7 subject4 87
    B subject5 subject3 subject8 74

    600 students information is in this sheet.

    10 new sheets have to be created like: subject1,subject2....subject10.

    These student rows have to be moved to respective subjects(classrooms) according to their choices and percentages.

    Sort the rows according to their first choice and then sort according to their percentages.
    If subject1 is the first choice of 70 students, the top 60 students of these 70 have to be allocated subject1(these student rows should be moved to subject1 sheet).
    Likewise, all the students' first choices are carried out.

    If any student rows are remaining second choice is carried out in the same manner.
    If there are any students whose choices are all filled, they have to be allocated some other classroom where there is vacancy.

    For example,
    student 560:
    choice 1: subject 5
    choice 2: subject 9
    choice 3: subject 2

    if all the subjects are filled, then to some other sheet, this row has to be moved where there is vacancy.
    Since there are 10 subjects(classrooms) and 600 students.
    Every student row is moved to some sheet or the other.

    Please help me. Thanks in advance.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Moving student rows to respective subject sheets

    Please see the attached.
    Attached Files Attached Files
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Registered User
    Join Date
    10-06-2012
    Location
    Trichy, India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Moving student rows to respective subject sheets

    Thank You very much. Your solution has helped me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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