Thread: How do I get random numbers from a certain range?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default How do I get random numbers from a certain range?
Hello,

If your numbers are in A1:A468, select 64 cells and array-enter
=Random_Pick(A1:A468)

My UDF Random_Pick you can get he
http://sulprobil.com/html/random_pick.html

Regards,
Bernd
Reply With QuoteReply With Quote