Lucky Draw

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've a name list of 300 persons. I need to make a lucky draw by random
selection at the basis of 1 by 1. The is no duplicate prize winner. Could
anyone help me.
 
Say your list of names is in Column A. In Column B in the first cell enter
"Rand()" without the quotes. Drag this formula down as far as the names go.
Sort both columns by Column B. Pick the first name. HTH Otto
"aggregate sum over the periods"
 
That should be "=Rand()". Otto
Otto Moehrbach said:
Say your list of names is in Column A. In Column B in the first cell
enter "Rand()" without the quotes. Drag this formula down as far as the
names go. Sort both columns by Column B. Pick the first name. HTH Otto
"aggregate sum over the periods"
Click to expand...
 
Back
Top