need to set up a formula to pick random numbers
 

i have a list of numbers and i would the computer to pick 6 of them .
1,2,3,5,6,13,16,17,18,20,21,22,23,25,26,27,28,32,3 4,35,36,40,42,44,46,47,48,50 and 50. this is for the lotto. each time i need to get 6 new numbers.
I have no back ground so please make this as easy as you can thank

Joe

need to set up a formula to pick random numbers
 

Courtsey MAX who gave this solution yesterday....

Enter your numbers in Col A

Put in B1: =RAND()
Copy down to B6

Put in C1: =INDEX(A:A,RANK(B1,$B$1:$B$6))
Copy C1 down to say, C6, to return 6 random names from the list in col A
Press F9 to regenerate.


"Joe" wrote:

i have a list of numbers and i would the computer to pick 6 of them .
1,2,3,5,6,13,16,17,18,20,21,22,23,25,26,27,28,32,3 4,35,36,40,42,44,46,47,48,50 and 50. this is for the lotto. each time i need to get 6 new numbers.
I have no back ground so please make this as easy as you can thank

Joe

need to set up a formula to pick random numbers
 

IN B1 I PUT =RAND() AND IT DIDNT WORK
"Sheeloo" wrote:

Courtsey MAX who gave this solution yesterday....

Enter your numbers in Col A

Put in B1: =RAND()
Copy down to B6

Put in C1: =INDEX(A:A,RANK(B1,$B$1:$B$6))
Copy C1 down to say, C6, to return 6 random names from the list in col A
Press F9 to regenerate.


"Joe" wrote:

i have a list of numbers and i would the computer to pick 6 of them .
1,2,3,5,6,13,16,17,18,20,21,22,23,25,26,27,28,32,3 4,35,36,40,42,44,46,47,48,50 and 50. this is for the lotto. each time i need to get 6 new numbers.
I have no back ground so please make this as easy as you can thank

Joe

need to set up a formula to pick random numbers
 

I can't think of any reason for its failure...

What happens when you put =RAND() in B1 and hit ENTER?

If you can share your email id then I can mail a worksheet with the formulae
filled in.

My id is . You can write to me there if you do not
want to publish your email.

"Joe" wrote:


IN B1 I PUT =RAND() AND IT DIDNT WORK
"Sheeloo" wrote:

Courtsey MAX who gave this solution yesterday....

Enter your numbers in Col A

Put in B1: =RAND()
Copy down to B6

Put in C1: =INDEX(A:A,RANK(B1,$B$1:$B$6))
Copy C1 down to say, C6, to return 6 random names from the list in col A
Press F9 to regenerate.


"Joe" wrote:

i have a list of numbers and i would the computer to pick 6 of them .
1,2,3,5,6,13,16,17,18,20,21,22,23,25,26,27,28,32,3 4,35,36,40,42,44,46,47,48,50 and 50. this is for the lotto. each time i need to get 6 new numbers.
I have no back ground so please make this as easy as you can thank

Joe