On 5-7-2014 22:58, Pikov Andropov wrote:
Luuk has written on 7/5/2014 5:01 AM:
On 5-7-2014 00:08, Pikov Andropov wrote:
I have a list of names in column A.
I would like 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
Thanks.
Yes, this can be done in Calc
First,assign a unique number to the names, i did put those number in
column B, so i get:
Names Seqeuence
Jack 3
Jill 2
Sam 1
Susan 4
Bill 6
Joe 5
Then, i have this foruma in D2:
=INDIRECT("A"&TEXT(B2+1;"0"))
which i copy from B2 to B3..B7
What am I copying from B2 to B3..B7 if the formula is in D2???
i get:
Names Seqeuence
Jack 3 Sam
Jill 2 Jill
Sam 1 Jack
Susan 4 Susan
Bill 6 Joe
Joe 5 Bill
Last bit:
In E5: =D2&","&D5
Copy this from D2 to D3..D4
Result:
Names Seqeuence
Jack 3 Sam Sam,Susan
Jill 2 Jill Jill,Joe
Sam 1 Jack Jack,Bill
Susan 4 Susan
Bill 6 Joe
Joe 5 Bill
Next time, the sequence is different
Do I change the sequence numbers by hand????
Yes, or you could write a macro which can do this for you .... ;)
--
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
