HELP! Randomly assign

  • Thread starter Thread starter doris
  • Start date Start date
D

doris

I need to randomly assign students to advisors. I will have about 200
students and 20 differnt advisors. Is there a way to do this on excel?
thanks
 
Doris,

Next to your students list, use function =RAND() in an empty column. This
will generate random numbers between 0 and 1.
You can then sort by these numbers, so as to get a random student list, and
assign the first 20 to the first advisor, the next 20 to the second and so
on.

Note: you could use function =INT(RAND()*20)+1 instead to get random numbers
ranging from 1 to 20, which could be used directly as the advisor number,
but there's no guarantee that you'll get an even split (I tested it and got
numbers of students per advisor ranging between 5 and 15).

HTH,
Nikos
 
Assign each advisor a number 1 to 20. Copy this formula into a colum
next to a list of student names :-
=INT(RAND()*20)+1

Which puts a number against each name. I suggest you then copy th
formula column and Edit/Paste Special Values to convert them to number
because they will change if the sheet recalculates. Sort on thi
column.

You could use VLOOKUP() to add the advisor name
 
Back
Top