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

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