View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Generate random number from a list

Tools - Add-ins ... Select Analysis tool pack.

Enter this in the cell for your random values.

=INDIRECT("A"&RANDBETWEEN(2,300))

Keep in mind that when you recalculate the cell, it will change.

"Arnie" wrote:

I have a list in cell A2:A300. There are not just integer values. Is there a
way to generate random values from that list even though some of the number
have decimals?