How to Use an Excel List for a Random Drawing

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Generate a random number for a drawing.

You don't need specialized software to get an accurate result for a random drawing. Although Excel is primarily known for its use as a financial tool, it has other functions that will generate a random number that you may use to determine the winner of a random drawing. A numbered list of entrants together with Excel's random number generator will give an instant answer. Using Excel to pick a winner also provides an unbiased result.


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

Video of the Day

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


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

Step 4

Click on A1, and drag the cursor to cell A2. These two cells should now be highlighted.


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


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


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

Video of the Day




Report an Issue

screenshot of the current page

Screenshot loading...