Setting up Excel to pick numbers for my list

yes you can do that and if you dont know how to do it just see the help file you will find it there

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

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

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

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

I am sorry but i dont understand the formula.
please show me with real numbers in it.