View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fruitchunk fruitchunk is offline
external usenet poster
 
Posts: 35
Default How to generate random numbers from a range of cells?

I have a list of 25 differnt numbers in cells from A1 to A25
How can I randomly pick 5 numbers from the range A1:A25
I would like the 5 number to show up in cells C1 to G1

Thanks