Browse » Home
Saturday, January 14, 2012
How to Use an Excel List for a Random Drawing
1. Construct a list of contest entrants. If you already have a list with consecutively numbered entrants, skip to step 6. If not, open a new spreadsheet in Excel.
2. Click on cell B1. Enter, or copy and paste, the first person's name. Click on cell B2, and enter the next name. Continue down the column until you have entered all the names.
3. Assign a consecutive number to each entrant starting with 1 and ending with N, where N is the total number of entrants that you have. Click on cell A1, and enter '1.' Click on cell A2, and enter '2.'
4. Click on A1, and drag the cursor to cell A2. These two cells should now be highlighted.
5. Move your cursor to the bottom right corner of cell A2 until a solid black cross (one without arrows) appears. Click and drag this black cross down column A until you reach the last name. Each number should now correspond to a name to the right of it.
6. Click on any empty cell in the spreadsheet. Enter the following formula to generate a random number: =RANDBETWEEN(1,N)N is the total number of entries that you have. For example, if you have 100 contestants, you would enter: =RANDBETWEEN(1,100)Don't put spaces between any of the terms in the function.
7. Hit 'Enter' to receive a random number between 1 and N. That number corresponds to the winning entry in your list. To generate another random number, move your mouse to the random formula cell again, and hit 'Enter' again.