I have a list of 15 numbers and I want to randomly pick 6 numbers from that list. How do I do it?
K Ken Jun 30, 2004 #1 I have a list of 15 numbers and I want to randomly pick 6 numbers from that list. How do I do it?
M Mike Q Jun 30, 2004 #2 Ken Go to Tools>>Add-Ins...>>Check Analysis ToolPack if not checked. Now in A1 type =randbetween(1,15). Press F9 to rescramble. Mike Q.
Ken Go to Tools>>Add-Ins...>>Check Analysis ToolPack if not checked. Now in A1 type =randbetween(1,15). Press F9 to rescramble. Mike Q.
J jeff Jun 30, 2004 #3 Hi, One simple way is to number your list from 1 to 15; in a separate cell enter =INT(RAND()*10). each time you hit F9, you'll get a new random calculation. use that. (You can also copy/drag this down to get a set of random numbers.) jeff
Hi, One simple way is to number your list from 1 to 15; in a separate cell enter =INT(RAND()*10). each time you hit F9, you'll get a new random calculation. use that. (You can also copy/drag this down to get a set of random numbers.) jeff
J JE McGimpsey Jul 1, 2004 #4 Take a look at http://www.mcgimpsey.com/excel/udfs/samplenoreplace.html
