• Home
• Products
  Complete Product List New Products Free Products Analysis Products Charting Products Data Products Macro Books Specialty Products Time Saving Products Workbooks/Templates Products by Others iPhone Applications
• Product Collections
  Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis Collection Time Saving Collection
• Save $'s
  Volume discounts Past customers discounts Buy a collection! Buy the Productivity Suite!
• Download
  Download Information Download Purchased Software Download Upgrades Download Trial Versions Download Free Products
• Support
  Support How to Contact Us Top Support Questions Money Back Guarantee Ordering FAQ's Product FAQ's How to Open and Use Our Products Excel Problems & Solutions Links to other Excel sites How to repair Microsoft Excel Need more help? Let us connect computers
• Company
  About Add-ins.com LLC How to Contact Us Customer Feedback Policies License Agreement

Random Sampler for Microsoft® Excel® 97, 2000, 2002, 2003, 2007, and 2010 Randomly sample a single worksheet Randomly sample multiple worksheets at a time Exclude or include from sampling       based on a value test Exclude or include from sampling based on       entries in key columns or if row colored Mark rows that are selected       with color or a cell entry Able to handle very large databases Watermark sample data for verification

If you need  to sample a set of data, the Random Sampler add-in will quickly and easily obtain the samples for you.   The main dialog gives you the following options:

The first group of three options is designed for small databases.  The second group of three options can handle millions of rows across many worksheets.  We ran a test of extracting 8,000 samples from a group of worksheets containing close to 3 million data rows.  The Random Sampler did the task in 30 seconds.

The first option in each group allows you to extract samples from the data rows on the active sheet.  If you have many worksheets that need sampling, the second option in each group will sample them for you.  You can have it extract samples randomly from all specified sheets or specify that N samples are to be extracted from each sheet.

To help you control which rows are part of the data to be sampled, you may use the following dialog:

Additional dialogs have options that allow you to insert the source workbook, worksheet, and row number of the extracted sample data, to specify the marker column if you use the third option in the above dialog, and to specify the text entry.

Once you have supplied the above, the Random Sampler asks you how many samples you want and then either extracts them or identifies them based on your selections above.  Blank rows are ignored.

The third option in each group on the main dialog, "Extract sample cells from a range of cells" is a great way to sample a list like the following:

The Random Sampler is especially useful if you are auditing data and want to quickly and easily select your samples.

Order online from our secure service. Get delivery in minutes!

US $49.95

Customers who looked at the Random Sampler also looked at:

• Random Number Generator - Random numbers the easy way.

View Cart US $49.95 Quantity Discount 2 10% 3 20% 4 30% 5-9 40% 10 or more 50%

Order online from our
secure service
Get delivery in minutes!

Order Risk Free
Money back guarantee
if not satisfied

Buy individually or
save by buying the Productivity Suite