HOW CAN I SELECT A RANDOM NUMBER IN A CERTAIN SCOPE

[rodger]

HI:
I only want create a random number in the certain scope,ie.the number of
a1:a5 is 2,5,16,17,3,what i want is that create a random number
in(2,5,16,17,3) in b1.

 

[JE McGimpsey]

If I understand you correctly:

B1: =INDEX(A1:A5,INT(RAND()*5)+1)

 

[Tushar Mehta]

For options focused on not repeating an earlier selection, see the
Excel/Tutorials/Random Selection page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions