Re: How do I set up a random name generator in excel (school use)
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Sat, 30 Sep 2006 23:04:33 -0400
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" <mochapo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:64186914-97DD-48A6-9404-83BE9BCA0F68@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: Links and sorting
- Next by Date: Re: How do I set up a random name generator in excel (school use)
- Previous by thread: Re: How do I set up a random name generator in excel (school use)
- Next by thread: Re: Using a formula to perform multiple functions.
- Index(es):
Relevant Pages
|
