C Cindi Oct 3, 2003 #1 I would like to select individual names from a database of names randomly for a drawing. Can someone send me the steps.
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 Oct 3, 2003 #2 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
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
