Random generator

  • Thread starter Thread starter SKA
  • Start date Start date
S

SKA

Hi,

I would like to know if Excel can randomly select a
string from a given list.
 
Let's say your list is in A1:A100

=INDEX(A1:A100,INT(RAND()*100)+1)

If you have the ATP loaded, you could use

=INDEX(A1:A100,RANDBETWEEN(1-100))
 
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

random number generator 6
eliminate negative value from normal random number distribution 4
Help Please! Random generator issue. 2
Randomly Select cell from filtered list 1
Random Numbers 2
random letter generation 5
Random Selection 3
Generating random numbers 2

Back
Top