View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard[_30_] Richard[_30_] is offline
external usenet poster
 
Posts: 1
Default Random Sample with proportions

I want to create a random sample for employee focus groups. In the
final sample, I want to have a representative number of gender,
city/state, job level and ethnicity (all fields in the spreadsheet).
So for example if there are 50% males and 50% females, I want 50%
males and 50% females in the final random sample. If the process
involves a macro or VBA, I would appreciate it if you would let me
know how to insert it into a file then run it.

Thanks.