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?
 

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

Top