
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
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__ --> |