Random name

  • Thread starter Thread starter perlaparedes
  • Start date Start date
P

perlaparedes

hello,

Does anyone know the formula for random name selection using one
column?

thanks,
 
One way:

Assume you have 15 names in the range A1:A15.

=INDEX(A1:A15,INT(RAND()*15)+1)

Will return a different name (although repeats are possible) every time a
calculation is triggered. To make a new selection just press F9.

Biff
 
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 Selection 3
Selecting random names from lists 1
random between function 8
Black rectangle 2
Select from a list 2
random of 4 names 1
Help Please! Random generator issue. 2
can I use information from another sheet modify it, into a formula 3

Back
Top