Thread: RAND() / RANDBETWEEN() FOR SPECIFIC ARRAY
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
  
Posts: 913
Default RAND() / RANDBETWEEN() FOR SPECIFIC ARRAY
On Fri, 8 Aug 2008 23:38:00 -0700, FARAZ QURESHI
wrote:

How can one derive a random number from a specifc array, for example a random
selection from {2, 4, 16, 256, 65536}

Try this formula

=CHOOSE(RANDBETWEEN(1,5),2,4,16,256,65536)

Hope this helps / Lars-Åke
Reply With QuoteReply With Quote