How do I create a random sample from a list?
I have a list of inputs and need to be able to fill empty cells with samples
from that list in a random fashion without replacement. |
How do I create a random sample from a list?
With your data list in Y1 to Y25,
Enter in Z1: =RAND() And copy down to Z25. Then try this formula anywhe =INDEX($Y$1:$Y$25,RANK(Z1,$Z$1:$Z$25)) And copy down 25 rows ... OR less if need be. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "swrath" wrote in message ... I have a list of inputs and need to be able to fill empty cells with samples from that list in a random fashion without replacement. |
All times are GMT +1. The time now is 01:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com