Selecting random names from lists
 

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.

Selecting random names from lists
 

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:D$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
---
"Jim" wrote:
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.