At 18:08 04/07/2014 -0400, Pikov Andropov wrote:
I have a list of names in column A. I would like to click something
and produce a list of random pairs, say in col B.
For example, suppose I have
Jack
Jill
Sam
Susan
Bill
Joe
I click and get
Jack, Jill
Joe, Susan
Sam, Bill
I don't save the result, and the next tie I run it, I get
Sam, Jack
Bill, Joe
Susan, Jill
What you are doing is really just shuffling your six names.
o Do you want to retain the names in their original order in column
A? If so, copy the names to column B.
o In column C, enter =RAND() and fill it down the relevant part of the column.
o Select the relevant rows in columns B and C.
o Go to Data | Sort... and sort by column C.
The values in column B will be shuffled according to the random
values in column C. An incidental effect of this is to recalculate
the random values in column C, so all you need to do to produce
another shuffling is to repeat the sort process, which will use those
new random values.
If you actually need the values in pairs as you have described, you
can use something like
=INDIRECT("B"&ROW()*2-1)&", "&INDIRECT("B"&ROW()*2)
in another column.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
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
