Random numbers plus assigned number

**mutchdea** · 09-28-2009, 09:52 AM

Hi all,

I have a group of 172 students. I want to be able to assign a student a teacher color and the vlookup will put that student into that teachers sheet. Which I did. However, if a student doesn't get an assigned color I want to randomly generate a number and have that student go into a teachers sheet.
Sound confusing!
For example:
Any student that gets their cell highlighted green (colorcell=4), then they go into Mr. Wilson's class. Plus Mr. Wilson also takes any kid whose random number is between 1 and 20.
I have attached the sheet so you can get a better idea.

Thanks

**teylyn** · 09-28-2009, 03:44 PM

Hi

without looking at your file, the following formula creates a random number between 1 and 20

=ROUND(RAND()*19,0)+1

**shg** · 09-28-2009, 09:00 PM

teylin, your use of ROUND biases the endpoints to have half the probability of the interior points. To generate a random number between 1 and 20 with uniform distribution,

=int(rand()*20) + 1

I don't think that solves the OP's problem though, but I don't understand well enough to make a suggestion.