How to Do a Random Drawing in Excel

Save
Next Video:
How to Export a Chart in Excel to a JPG....5

Doing a random drawing in Excel is easy, so long as you're using the right tools. Do a random drawing in Excel with help from a self-taught web developer in this free video clip.

Part of the Video Series: Basics of Microsoft Excel
Promoted By Zergnet

Comments

Video Transcript

Hi, I'm Christina Chiu, and I'm a computer web specialist. And today, I'm going to show you how to do a random drawing in Excel. So, if we open up our Excel here, you'll see I have a sample table ready. Column one is, consecutive numbers one through six, and column two is, random names and column says, random draw. Now, we're going to insert our random draws, if we select a cell here. So, we're going to select cell C and select formulas on the tabs above. So, when we select formulas, we're going to select Insert Function, so click on Insert Function. And to do the random function, it's just the colon equals rand between, between one and a hundred. And then, we're going to click on Go right here and then, select function, Rand Between, click on O.K. Now, the bottom is going to be one and the top is going to be 100. Click on O.K., and Random, we do 60. Now, if you want to do this for the other cells, it's like the another cell, Insert Function. Then, oops, Rand Between, click on Go, click on O.K. Bottom ,one, top 100 and then, O.K. And then, select at one. So, you could do that for each of the cells and then, it'll do a random drawing of variables, of numbers. Alright, that is how you do a random drawing in Excel, thanks so much for your time, I'm Christina Chiu.

Featured

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!