On 2013-11-12 04:17, Helen wrote:
A LO calc question. It's a bit trivial, but I'm sure it can be done.
Names of about 20 people. Draw names for Christmas gifts.
We can wait until we're all together in a couple of weeks, and that
will work, but can we do this by running a random number generator
in calc? Type 20 names into column one, then the same names again
in column 2, then run a random number generator to match them up?
I did something similar to this about a year ago (for a church dinner)
but for the life of me I just can't remember how I did it, and the
I get by googling don't work. (When I follow those instructions, the
function returns #NAME? in the cell.)
Thanks for any pointers,
If the selection is random, you could possibly select the same person
twice (or more) to match another person.
Just off the top of my head, you could have 4 columns. Names1 and next
to it random1 "=RAND()" copied down.
Repeat the 2 columns for the second list of names. Now highlight the
first pair (Names1 and next to it random1) and on the menu Data>Sort and
sort by the random number column. Do the same with the second pair.
Someone will have a far more elegant method, but at least you can start
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy