Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Excel 2002 vlookup rand



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



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.