[SLOVED] split list in the same column

i have 5 class

each class has 3 group of student

i need to split this list in equal group by class
by sending number of group in the column c
in vba code
thank you

name classe group
student1 1s1 1
student2 1s1 1
student3 1s1 1
student4 1s1 1
student5 1s1 1
student6 1s1 2
student7 1s1 2
student8 1s1 2
student9 1s1 2
student10 1s1 2
student11 1s1 2
student12 1s1 3
student13 1s1 3
student14 1s1 3
student15 1s1 3
student16 1s1 3

Code is as per result expected. If the students are 55, 30,..... etc how it is to be divided?r
Macro code:

Please Login or Register  to view this content.

Attached is a solution based on kvsrinivasamurthy's solution.

This version does split the class group in EQUAL groups (not 18 - 11 - rest as per your sample).
If the number of students is not divisible by 3, the remainer is added to group 1 and 2.
IE 39 students = 13 - 13 - 13
40 students = 14 - 13 - 13
41 students = 14 - 14 - 13
42 students = 14 - 14 - 14 ...

Please Login or Register  to view this content.