Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week
|
||
Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
||
|
|
|
|
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 option allows you to extract samples from the data rows on the active sheet. If you have many worksheets that need sampling, the second option 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 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.
Customers who looked at the Random Sampler also looked at:
|
|
| Copyright 2009 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |
