Setting up Excel to pick numbers for my list

Closed
Report
Posts
1
Registration date
Saturday August 30, 2008
Status
Member
Last seen
August 31, 2008
-
 Bob -
Hello,
I would like to use Excel program to pick 6 numbers for a list i have.
can ths be done? Thanks

6 replies

Posts
433
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
109
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
16
Registration date
Tuesday August 26, 2008
Status
Member
Last seen
June 6, 2009
10
yes you can do that and if you dont know how to do it just see the help file you will find it there
Posts
433
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
109
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
I am sorry but i dont understand the formula.
please show me with real numbers in it.
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
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
Just use the same ones each time. Numbers that have come up recently are NOT less likely to come up again.