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

Brian Barker has written on 7/4/2014 8:11 PM:
> 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.

Well, actually, it's not. :-) I want to create a list of pairs from a
subset of the names in column A.

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

I get a bunch of numbers < 1.

> o Select the relevant rows in columns B and C.
> o Go to Data | Sort... and sort by column C.

That sorts the names in B. But that doesn't give me pairs.

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

In addition to what I already have in B and C?

Thanks.

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