HOW CAN I SELECT A RANDOM NUMBER IN A CERTAIN SCOPE

  • Thread starter Thread starter rodger
  • Start date Start date
R

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.
 
If I understand you correctly:

B1: =INDEX(A1:A5,INT(RAND()*5)+1)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO RUN random percentage and copy of column values 1
How to create a column of pseudo random numbers with probability ' 2
Excel Repeating a RAND() function under certain conditions 0
Create random list - dublicates are okay but not right after each other 2
Use Numbers in Specific Cell 1
making random numbers, one greater than other 1
Choosing numbers randomly 4
Numbers better as Text? 7

Back
Top