If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Random Picker
How do I take a list of names and randomly 'pick' one from the list?
|
#2
|
|||
|
|||
Random Picker
Hi
if your list is in A1:A10 use the following formula =INDEX(A1:A100,RANDBETWEEN(1,10)) Note: the Analysis Toolpak has to be installed for this -- Regards Frank Kabel Frankfurt, Germany Angie wrote: How do I take a list of names and randomly 'pick' one from the list? |
#3
|
|||
|
|||
Random Picker
Close your eyes and point on the screen?
Assume the names are in A1:A100 =INDEX(A1:A100,INT(RAND()*(101-1)+1)) -- Regards, Peo Sjoblom "Angie" wrote in message ... How do I take a list of names and randomly 'pick' one from the list? |
Thread Tools | |
Display Modes | |
|
|