One way is to put the names in column A (say A1:A30) and put =rand() in B1:B30.

Then sort those two columns using column B as the primary key.

And pick off the top x number of names.

If you want, you can resort again to randomize the list.

mochapo wrote:

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.

--

Dave Peterson