In first column there are 38 persons, 2nd column 14 persons, its ok to repeat names only after that all are chosen once and not some are chosen more than others.Do you mind selecting the same person twice in x number of weeks?
How many names have you got?
That's not really random then?In first column there are 38 persons, 2nd column 14 persons, its ok to repeat names only after that all are chosen once and not some are chosen more than others.
Thanks in advance.
Younan
Very easy to make completely random but adding specifications much harder.'Slight' project creep as well.
This is a good page for ideas but it won't cope with the extra requirements.
Excel random selection: how to get random sample from dataset