How to Take a Random Sample in Excel (Reproducible)
You need a fair, random subset of rows to spot-check — but the RAND-and-sort trick reshuffles the moment you touch the sheet and can never be redrawn. Here's why, and the one-click way that gives you a sample you can reproduce.
Last updated: August 2026
| Before | After | |
|---|---|---|
| 1,000 rows (full table) | → | 50 rows (sampled, new sheet) |
| seed 7 | → | same 50 rows every time |
Why RAND and sort breaks
The classic recipe is a helper column of =RAND(), sort by it, and take the top rows. But RAND() is a volatile function: it recalculates on every edit, so the values reshuffle each time you touch the sheet and the sample you drew is gone. RANDBETWEEN has the same problem. Worse, there's no seed, so the draw can never be reproduced — an auditor can't verify or redraw the exact rows you sampled.
The 1-click way — Tellsheet's Random Sample
Select your table and run Random Sample. Set the sample size and a seed, and it writes a random subset to a new sheet with the header kept and the drawn rows left in their original order. Because it's seeded, the same seed always draws the same rows, so your audit is reproducible — note the seed and anyone can redraw the identical sample; change the seed to reshuffle. Your source table is never touched. Pairs with Find Outliers and Audit Data Quality.
Frequently asked questions
How do I take a random sample in Excel?
The manual way is a =RAND() helper column, sort by it, and keep the top N — but it reshuffles on every edit. Random Sample draws a subset to a new sheet in one click, and a seed makes it repeatable.
Why is RAND and sort unreliable?
RAND() is volatile — it recalculates on every keystroke, so the values change and your sample is no longer the one you drew. It also can't be reproduced.
Can I redraw the same sample later?
Yes — it's seeded, so the same seed always draws the identical rows. Change the seed to draw a fresh sample.
Does it change my original data?
No — the sampled rows go to a new sheet with the header kept and their order preserved; your source table stays as it was.
Related Excel guides
Draw a fair sample in one click
Random Sample writes a reproducible random subset to a new sheet — seeded, so the same seed always draws the same rows.
Get Tellsheet free See pricing