Thread: Lucky Draw
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default 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.