View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DOR
 
Posts: n/a
Default 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