Re: [libreoffice-users] Re: Can I do this in Calc?

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

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