|
| 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
May 17th, 2004, 10:21 PM
|
|||
|
|||
Random Picker
How do I take a list of names and randomly 'pick' one from the list?
|
|
#2
May 17th, 2004, 10:26 PM
|
|||
|
|||
|
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
May 17th, 2004, 10:30 PM
|
|||
|
|||
|
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 | |
|
|
Linear Mode
