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

At 16:54 05/07/2014 -0400, Pikov Andropov wrote:
> Brian Barker has written on 7/4/2014 8:11 PM:
> > 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.

It is: the list of pairs is simply a shuffling of the original set 
presented as a half-length sequence of pairs instead of a single 
list. It would help you see what need to be done if you can recognise that.

> > In column C, enter =RAND() and fill it down the relevant part of the column.
>
> I get a bunch of numbers < 1.

Well done: that's the idea.

> > Go to Data | Sort... and sort by column C.
>
> That sorts the names in B. But that doesn't give me pairs.

Again, that is the main part of the process: you have shuffled the 
values, but they are in vertical pairs, not yet horizontal ones.

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

Er, yes. You keep insisting you want the horizontal pairs - and this 
part just rearranges your shuffled list into the pairs you want. That's all.

Brian Barker  


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