Lucky Draw
 

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.

Lucky Draw
 

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"
. com wrote in message
...
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.

Lucky Draw
 

That should be "=Rand()". Otto
"Otto Moehrbach" wrote in message
...
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"
. com wrote in message
...
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.