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

6 replies

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 :
your list is in A1:A26
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
6
adobepro Posts 16 Registration date Tuesday August 26, 2008 Status Member Last seen June 6, 2009 10
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
3
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
2
I am sorry but i dont understand the formula.
please show me with real numbers in it.
2

Didn't find the answer you are looking for?

Ask a question
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
0
Thanks for the reply
I have these numbers
3,5,6,13,16,17,18,20,23,25,26,27,28,32,34,35,36,40,42,44,46,47,48,50,52 and 54

I would like to have the computer pick 6 of them.
i want to use the to play the lotto. So each week i will have the computer pick me a new slection.
thanks
0
Just use the same ones each time. Numbers that have come up recently are NOT less likely to come up again.
0