Related:
- Setting up Excel to pick numbers for my list
- My contacts list names - Guide
- Numbers to words in excel - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Whatsapp time setting - Guide
- Excel apk for pc - Download - Spreadsheets
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
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
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
adobepro
Posts
16
Registration date
Tuesday August 26, 2008
Status
Member
Last seen
June 6, 2009
11
Aug 31, 2008 at 10:37 AM
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
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
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
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
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
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