Here's another one.

Say you have 20 students. List their names in A1:A20. To randomly pick a
single student:

=INDEX(A1:A20,INT(RAND()*20+1))

Repeats are possible. To make another pick just hit function key F9. A new
pick will be made every time a calculation takes place.

Biff

"mochapo" wrote in message
...
I am a high school teacher and would like to use a random name generator
for
calling on students. Any guidance on how to set one up? I read an article
in
which the author stated a friend wrote an excel formula for doing this -
but
no further info.
Any help would be greatly appreciated.