Randomly assign codes to cells

G

Gemsie

Bit of a complicated one. I have a spreadsheet of students and the classes they take during different periods. Some periods don't have any data in, because they have a free period, but I need to randomly assign two specific study periods (using an ICT suite) per student.

However, there can only be a certain number of kids in the study period dueto the lack of computers!

Any ideas how it could be done?
 
Top