| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart, draw Normal Distribution curve | Setting up and Configuration of Excel | |||
| how do i draw equillbrium graph? | Excel Discussion (Misc queries) | |||
| How draw x-y picture | Charts and Charting in Excel | |||
| Draw Objects in Charts | Charts and Charting in Excel | |||
| How to Draw an arc which is 1/4 of a circle? | Charts and Charting in Excel | |||
Linear Mode
