How do I pull a random sample of people from a list in excel?
Double OOOPS!
I was hasty in saying that if you change the helper column to =RAND()
that the formula I suggested for column C still stands. It doesn't; it
needs to be changed to
=IF(ROW()-ROW($1:$1)SampSize,"",INDEX($A:$A,MATCH(SMALL(B:B ,ROW()-ROW($1:$1)),B:B,0)))
where SampSize refers to the variable, sample size.
I overlooked the MATCH expression, which was unnecessary in my version.
Declan O'R
|