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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need formula help 4
How can I make random selection from excel list? 2
Competition Time! 85
Excel Combining Field Name and Value in report row 1
Save RAND select number 3
Can Excel pick random numbers from 1-300 and not repeat numbers? 1
Can the computer be set to randomly select a row for a drawing? 1
Weighted Random Selection 5

Back
Top