Selecting random names from lists

[Jim]

I am wondering if there is a formula I could use to randomly select names out
of a six different lists and put them into separate columns in the same
spreadsheet or another spreadsheet.

 

[Max]

I'm not sure on your actual specs, but this easy random scramble set-up
should give a fairly good idea of how you can go about it.

Let's say you have 3 source lists of names within A1:A5, B1:B5 and C1:C5
Put in D1: =RAND()
Copy D1 across by 3 cols to F1, fill down to F5. This sets up the
"randomizing engine" for the 3 source lists.

Then place in G1: =INDEX(A$1:A$5,RANK(D1,D$1$5))
Copy G1 across by 3 cols to I1, fill down to I5. What you'll get is a random
scramble of the 3 source lists in cols A to C, in the corresponding cols G to
I. Pressing F9 will re-scramble the whole lot of results in cols G to I. Just
read-off the number of randomized names as may be desired from each list in
cols G to I. Adapt to suit.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik