# How can I select a random list of names from a group in Calc? [closed]

is there a formula that will select a random list of names from a large group using Calc? No repeats in selection required.

Thanks

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-28 20:20:52.596797

Sort by » oldest newest most voted

Hi @cflyte,

Could you be a little more specific about the formula you're drafting?

• Do you want a formula that will select a variable # of random names from a long list, or a formula that will select a specific # of random names from a long list?
• You say "No repeats in selection required." -- Are you implying that repeats in the selection are acceptable? (this nuance is important when designing the formula!)

Here's a quick formula for grabbing random names out of a list -- see if this works for you:

---+----------+-------------
|    A     |    B
---+----------+-------------
1 | Jim      |
2 | Jon      |
3 | Jem      |
4 | Jen      |
5 | Jan      |
6 | Jam      |
7 | Archibald|

In a separate column (I just chose cell B2), I used the following formula to select a random cell from my range

=INDIRECT("A"&RANDBETWEEN(1,COUNTA(A1:A7)))

I can get a list of random names by copying this formula into several cells B2 through B10 (etc...). Note that this list may have repeats.

You'll want to tweak the arguments to INDIRECT() and RANDBETWEEN() so that they accurately describe the bounds of your range. Otherwise you may get spurious results in your output stream (e.g. selecting a larger range than your data resulting in selection of empty cells, or selecting a smaller range and never picking certain names)

more

Another way to solve this problem is described in this file - Random names.ods

more

Thanks, these docs were great, I re-did them with up-dated screenshots. Hope that helps anyone who needs them http://www.gingerling.co.uk/how-to-ra...

( 2016-07-01 19:28:03 +0100 )edit

## Stats

Seen: 6,648 times

Last updated: Jul 06 '14