Is it possible to do it by a single-line formula(without using VBA)?

H

hello_lpc

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 |
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert dates! I cant do it now! 0
is it possible to refer to a cell using an expression? 4
is it possible to enter in text over a formula without deleting the formula? 3
is it POSSIBLE to create a Database in excel using VBA... 3
Is it possible to number lists separated by a space on Excel? 2
Is it possible to create a HTML web contact form for Entourage 2
Is it possible to create a 'Continuation Form' (not a continuous f 6
Is it possible to add rows to a range using input form 1

Top