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?
|