Select a block of cells to sample from choose the Sample... item from the Tools -> ZRandom submenu:

the samples will be place on the clipboard and can be pasted anywhere.
Options
Number of samples
Type the number of samples in this box Unique samples
If checked, each row will be sampled at most once. Equal weights
Each row has an equal probability of being sampled. Weights in
Select the column that contains the relative weights for each row. The values in this column should be numeric and greater than or equal to 0.
Z Random for Excel
Secure Payment Options
30 Day Money Back Guarantee
| Pricing: |
|
Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
See Also: OzGrid Excel Plus || Monte Carlo Add-In for Excel || Random Numbers Generator and Statistics || Numerical Searching Methods and Option Pricing Models || Finance and Statistics Models || Excel Add-ins or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS