|
| Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
|
|
If you need a set of random numbers in Microsoft Excel, you will find that generating random numbers is easier said than done, especially if the random numbers must be unique. Our Random Number Generator allows you to perform this task quickly and easily. The following screen shot shows how easy it is to fill in:
If you select the first option, you are prompted for how many random numbers to generate, the starting and ending values and if the numbers should be unique. The second option allows you to fill a selected range with random numbers. The third allows you to generate columns of random numbers. The following is the dialog that appears when you pick it:
The following is the output that resulted from the above If you select the second option, the following dialog appears, which lets you select the destination range (as multiple separate cells or ranges) and other key settings:
As the above illustrate, you control the starting and ending values and the number of random numbers generated. You can generate the output to a new workbook, a new worksheet, or pick the destination. You have the option to make the numbers unique and to generate random number across many columns so that you can create a large table of random numbers. Or, select just a range of cells and have it filled with random numbers. When you click OK on the above dialogs you are asked if there are numbers you wish to exclude from the set of random numbers that will be generated. If you respond yes, you can select a range of cells containing the numbers to exclude. The list that is generated will then exclude the numbers in the cells you selected.
Customers who looked at the Random Number Generator also looked at:
|
Order online from our Order Risk Free Buy individually or
|
| Copyright 2011 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |
