|
|||||||||
If you need a set of random numbers, you will find that generating random numbers is easier said than done, especially if the random numbers must be unique. Our Random Number Generator add-in for Microsoft Excel allows you to perform this task quickly and easily. It is compatible with Microsoft Excel 2003, Excel 2007, Excel 2010 and Excel 2013. The following screen shots show how easy it is to use the Random Number Generator:
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 |
||||||||
|
|||||||||