View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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