Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
the formula for random selecting | Excel Discussion (Misc queries) | |||
Selecting Random Data | Excel Worksheet Functions | |||
Selecting Random Data | Excel Worksheet Functions | |||
Selecting ALL names when using Insert/Names/Apply | Excel Worksheet Functions | |||
Selecting at random with weighted probability | Excel Worksheet Functions |