Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Selection
Can excel be used to randomly select numbers within a group. Ex I need to randomly select 14 accounts aout of a list of 150. How can I do this? -- petevang ------------------------------------------------------------------------ petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034 View this thread: http://www.excelforum.com/showthread...hreadid=386134 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Selection
You don't say if the accounts are consecutively numbered or not. If they are consecutively numbered you can use: Code: -------------------- int(1+(150*rnd(1))) -------------------- If they are not consecutively numbered then place the accounts into an array numbered 1-150 and use the formula above to generate a pointer into the array (likewise if the accounts are non-numeric) RND is a psuedo Random number generator. This means that it's results are reproduceable (if you restart Excel...). To reproduce a given set of 'Random' numbers you use the 'Randomize' statement. To give the numbers an almost totally random nature, use the statement: Code: -------------------- Randomise(Now()) -------------------- Code: -------------------- Sub Temp1() Dim I As Integer '* Randomize (Now()) For I = 1 To 14 Debug.Print Int(1 + (150 * Rnd(1))) Next I End Sub -------------------- Gives the following results over 3 runs: 94 78 114 67 85 52 79 95 124 58 36 40 125 132 46 47 35 46 81 100 33 70 143 150 120 37 51 140 122 21 14 93 45 24 122 52 101 92 148 71 98 133 If you want to make sure a number is not used twice then you will have to build an array of the numbers chosen (either in a string or using Redim) Regards Rich -- Rich_z ------------------------------------------------------------------------ Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737 View this thread: http://www.excelforum.com/showthread...hreadid=386134 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Selection
put the list of 150 accounts in column A starting in row1
in column B put in =rand() and drag down. Then sort A1:B150 on column B. Take the first 15 accounts -- Regards, Tom Ogilvy "petevang" wrote in message ... Can excel be used to randomly select numbers within a group. Ex I need to randomly select 14 accounts aout of a list of 150. How can I do this? -- petevang ------------------------------------------------------------------------ petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034 View this thread: http://www.excelforum.com/showthread...hreadid=386134 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random Selection | Excel Discussion (Misc queries) | |||
Random Selection | Excel Worksheet Functions | |||
Random Selection | Excel Worksheet Functions | |||
Random Selection | New Users to Excel | |||
Random Selection | Excel Programming |