View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kashyap Kashyap is offline
external usenet poster
 
Posts: 131
Default Pick Ref# randomly on an average

Hi Max, I'm not getting the expected result..

I need proportional number of items from each group without any
duplicate.(proportional to the total size of each group)





"Max" wrote:

Here's a nice working sample to demonstrate the suggested set-up:
http://freefilehosting.net/download/4575g
Weighted Randomization Model.xls

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---