MintyTools
RandomSample=MINTY.RANDOMSAMPLE()
Buy MintyToolsBuy$69

Random Sample

Select a random sample from transactions, invoices, or other records for review.

  • One of 30 tools in MintyTools
  • Excel 2013–365 on Windows
  • 14-day money-back guarantee

Try it - click the ribbon

Payables.xlsxExcel
A2INV-1041
ABC
1InvoiceAmountSample
2INV-10411,250
3INV-1042980
4INV-10432,410
5INV-1044315
6INV-10454,780
7INV-10461,120
8INV-1047660
Invoices
Ready
Seven invoices. Pick three to test, at random, and keep a record of which.

How it works

Use Random Sample when you need an unbiased selection of transactions, invoices, rows, or other records from a population.

Choose the source range and requested sample size, then let MintyTools select records randomly from that population.

The tool uses Excel’s pseudorandom number generator to select records from a larger population. Choose the population and sample size to suit the review you are performing.

Produce a repeatable sampling workflow for audit or analysis without manually selecting records or constructing helper formulas.

Inside Excel

The real thing.

The demo above is a simplified web version. This is Random Sample running in Excel.

Random Sample feature working in MintyTools for Excel

Keep exploring

See the whole Cells & Ranges sheet or every tool.

MintyTools demo

Video not loading? Watch on YouTube ↗