Assist Pro+ · Sampling
Use Tool Finder if you do not know the ribbon group. Confirm the final location in your installed version.
Tool guide
Select a random sample
You have a defined population and need a selection method you can describe to the reviewer.
What it solves
Use this when…
You have a defined population and need a selection method you can describe to the reviewer.
Expected result: A sample list with a recorded population and selection basis for professional review.
How to use
Follow these steps
Try the action on a copy of your workbook first.
1
Define the population
Confirm period, completeness, filters, unique item identifiers and sample size.
2
Record the method
Use the random sampling action and keep the parameters or seed where available.
3
Check the selection
Trace selected items back to the source and document exclusions or replacements.
Before you finish
Check the output
Confirm the result against the source and keep your own judgement in the loop.
Unexpected input format
Check headings, selected ranges and text/number formats before running. Work on a copy for consequential changes.
Ready to explore?
Make Excel work better for you.
Start with the current 10-day trial, or speak to us about what your team needs.