Re: Excel 2002 vlookup rand

- put the list in one column
- put =RAND() in the corresponding cells of the adjacent column
- sort both columns on the random column
- take successive pairs of names as the teams

Jerry

affiori wrote:

> Hi!
>
> Is there a formula to produce three *random* arrangements of a list
> with 6 names (each team of two)
>
>   # list of names
>   *  name 1
>   *  name 2
>   *  name 3
>   *  etc.
>
> The random output should be something like this:
>
>   Team A        Team B        Team C       
>   name 1        name 4        name 3
>   name 6        name 2        name 5
>
> I am a beginner as you may have guessed ;-)
> How can i achieve the above using vlookup() and rand()?
> So far i have only been able to list single names and produce a random
> output by doing:
>
> =VLOOKUP(RAND(),B:C, 2)
>
> B       C
> 0       name 1
> 0.5     name 2
> 0.1     name 3 etc.
>
> Now i'm stuck.
>
> Thanks!
> Al