As I wrapped up the Christopher Hart Cartoon Faces Book Giveaway, I thought I share with my readers a tutorial on “How to do an easy Random Drawing using Excel.” If ever you don’t want to print out entry chits and draw by hand, these five easy steps will make things less time consuming for you.

### STEP 1:

- In Column A, type in or import all the names of the people who are part of the drawing.
- In cell B1 type in the formula =RAND() This will generate a random number in B1 between 0 and 1.
- Copy the formula in B1 and paste it down the rest of the column so each name has a random number next to it.

### STEP 2:

- In excel, hit CTRL-A (PC) or Highlight all the cells with data in it in Columns A and B.
- Click on the DATA tab and then the SORT button. This will pull up a new dialogue box.
- Choose Sort by Column B and it doesn’t matter if you choose smallest to largest or largest to smallest. Select OK.
- What this does is the same thing as having physical entries that you mix up by hand. You have randomly assigned each person a number and that number sorted mixes up all the entries.

### STEP 3:

- Go to www.random.org/integers/
- Since I want to have only one winner I put “1” where it says “Generate X random integers”
- Value set is 1 to 37 because I have a total of 37 rows. If I had a header in row one such as “NAME” and “RANDOM NUMBER” this would have pushed my data from rows 1-37 to rows 2-38. So be sure to only include the rows of the data and not the headers.
- Select Get Numbers.

### STEP 4:

- Your number has been generated and the results show up here. In my case the result was number 25.

### STEP 5:

- Return to excel and scroll down to the 25th row.
- That is your winner.

Hope this helps as you do drawings on your own. Please let me know if you have any questions.

Interesting. Why do you recommend randomizing the row of choice? If you use the rnd() function on the whole list, wouldn’t it be just as random to select the smallest (say) random number?

btw–I like your comic.

Typically name lists are alphabetical so I like mixing it up before picking.

Good point about using smallest random number. But I like the two step random picking. Another step of mixing.

Excel rocks. I use it all the time. When I was still working I did my budget on Excel. A great program that allows you to do so many things.

Have a fabulous day. 🙂

Too much to learn about it and I have forgotten most.

Being that you are a cartoonist, I just assumed you had figure out a way to draw things with excel which would be very odd but then…

I think I saw an artist that did just that. Drew with the blocks of excel. It was cool.

Forget cartooning, you can animate with it! http://www.news.com.au/technology/excel-lent-animator-creates-stop-motion-using-spreadsheets/story-e6frfro0-1226449140759

Wow that is cool Kim…thanks

Random drawing? I was expecting some artwork!

that’s today!!

What Lisleman & Binky said was what I expected too Mister Bearman

I should have said raffle

How do you know if Excel isn’t being biased? 😛