Steps to randomly select names for drawings

C

Cindi

I would like to select individual names from a database of
names randomly for a drawing. Can someone send me the
steps.
 
P

Peo Sjoblom

One way..

Assume the names are in A2:A200, copy the name list to a
new sheet.. In B2 put

=RAND()

copy down to B200.. Now sort on column B ascending..
Select the first x number of names in column A
That would be your random selection for the drawing..

Regards,

Peo Sjoblom
 
Top