Setting up Excel to pick numbers for my list

Closed
Anonymous User - Aug 31, 2008 at 05:10 AM
Bob - Sep 1, 2012 at 07:21 PM
Hello,
I would like to use Excel program to pick 6 numbers for a list i have.
can ths be done? Thanks
Related:

6 responses

Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 110
Sep 3, 2008 at 04:35 AM
What you can do is use the function RAND, which generates random numbers between 0 and 1
You multiply it by 25 and then round it in order to get numbers between 0 and 25 (that is to say possibly 26 numbers corresponding to your list).
Then use the function OFFSET to choose a number in your list
Example :
B1 =ROUND(RAND()*25;0)
B2 =ROUND(RAND()*25;0)
...
C1 =OFFSET(\$A\$1;B1;0)
C2 =OFFSET(\$A\$1;B2;0)
...
Then press F9 for a new draw
Ivan
adobepro Posts 16 Registration date Tuesday August 26, 2008 Status Member Last seen June 6, 2009 11
Aug 31, 2008 at 10:37 AM
yes you can do that and if you dont know how to do it just see the help file you will find it there
Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 110
Sep 2, 2008 at 09:12 AM
Hi Joe,
could you tell us more about what you want to do ?
what does your file look like ? where is the list of the numbers you want to pick out ?
Ivan
Anonymous User
Sep 4, 2008 at 05:30 PM
I am sorry but i dont understand the formula.
please show me with real numbers in it.

Didn't find the answer you are looking for?

Anonymous User
Sep 1, 2008 at 09:42 PM
I need someone to set this up for me please let me know if you can do this of if you know of anyone who can.

thanks I will send the numbers i will need .

thanks

Joe
Anonymous User
Sep 2, 2008 at 10:06 AM