Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

AutoFill with Random Numbers AutoFilling is a great tool in Excel; it allows you to place a wide range of values into cells. If you want to use it to add random numbers to a worksheet, you’ll be disappointed—Excel won’t do it. You can, however, use one of the tools available in the Analysis ToolPak to generate a whole bunch of random numbers. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Determining a Random Value One of the better-known VBA functions is Rnd, which allows you to generate a random value between 0 and 1. You can use this for all sorts of purposes, as described here. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Generating Double-Digit Random Numbers Normally you use the RAND and RANDBETWEEN functions to generate random numbers. What if you want to generate random numbers within a certain range but exclude some numbers in that range? Here’s some ideas on how to get what you want. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Picking Different Random Numbers from a Range If you need to randomly select multiple items from a list, you obviously don’t want those items to duplicate each other. This tip explains a couple of different ways you can derive unique random elements from a list, all through the use of formulas. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Random Numbers in a Range The RANDBETWEEN function is a valuable worksheet function that allows you to generate a random number between some boundary values that you specify. This tip explains how to use the function. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)