Hi,
My school principal gave me the results of all Form 3 students(= 9th
Grade in US).[see attachment]
I have to assign each student to a new class for next year (namely
4A,4B,4C,4D)according to their form position in Form 3(col. CJ) and
their preference(col. CV to CZ, 1=4A, 2=4B, 3=4C...). The max. class
size for Form 4 is 42 and we have about 190 students.
I know it is easy to input the result manually, but is it possible to
do it by formula? I'm just an excel newbie.
Thanks
George
+-------------------------------------------------------------------+
|Filename: excel2.JPG |
|Download:
http://www.excelforum.com/attachment.php?postid=5035 |
+-------------------------------------------------------------------+
--
hello_lpc
------------------------------------------------------------------------
hello_lpc's Profile:
http://www.excelforum.com/member.php...o&userid=31304
View this thread:
http://www.excelforum.com/showthread...hreadid=561718