Re: [libreoffice-users] Can I Do This in Calc?

At 20:11 04/07/2014 -0400, Pikov Andropov wrote:
> I have a list of names in col A. What I want to do is find a quick 
> and dirty way to create a random list of pairs (different each time I do it).
>
> Example
>
> Jack
> Joe
> Sally
> Sue
> Paul
> John
> Ringo
> Earl
>
> The desired result would be written to col B (or perhaps to B and C 
> if that's easier) and would be something like
>
> Earl, Sally
> Paul, Ringo
> Sue, Jack
> John, Joe
>
> The next time I do it, the result might be
>
> Sally, Sue
> Paul, Joe
> John, Ringo
> Earl, Jack.

The solution to your previous problem is easily extensible to this 
slightly large one.

;^)

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