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