[libreoffice-users] random # in calc

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
instructions
I get by googling don't work.  (When I follow those instructions, the
function returns  #NAME?  in the cell.)
Thanks for any pointers,

-- 
Helen
using Linux, suse12.3

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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