Thread: How do I set up a random name generator in excel (school use)
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How do I set up a random name generator in excel (school use)
Let's says you have 30 student names from A1:A30

B2 =INDEX($A$1:$A$30,RANDBETWEEN(1,30))

Require Analysis ToolPak Add-Ins


"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.
Reply With QuoteReply With Quote