Related:

- Setting up Excel to pick numbers for my list
- My contacts list names - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Whatsapp time setting - Guide
- Numbers to words in excel - Guide
- Whatsapp country code list - Guide

## 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