Ask Your Question
0

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

asked 2013-01-12 05:51:59 +0100

cflyte gravatar image

updated 2014-07-06 13:17:25 +0100

bencomp gravatar image

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 flag offensive 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

2 Answers

Sort by » oldest newest most voted
1

answered 2013-01-13 15:47:12 +0100

qubit gravatar image

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:

In a new Calc spreadsheet, I added the following names:

---+----------+-------------
   |    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)

edit flag offensive delete link more
1

answered 2013-01-14 10:59:37 +0100

JohnSUN gravatar image

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

edit flag offensive delete link more

Comments

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...

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

Question Tools

Stats

Asked: 2013-01-12 05:51:59 +0100

Seen: 6,537 times

Last updated: Jul 06 '14