Generate unique random numbers, strings, passwords in Excel - Random Number Generator

Random Generator for Microsoft^® Excel^®

Random Number Generator for Excel - generating random values, custom lists, passwords

For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

Do you need random values in Microsoft Excel?

Generate random numbers in Excel

• Want to fill the range with random numbers: integers, real numbers, Boolean or dates?
• Need unique random numbers in Excel? For instance, assign unique random numbers to a list of clients, locations, commodities etc.
• Want to have random strings, e.g. GUID or codes of a given pattern?
• Have to generate random passwords with different character sets, e.g. A - Z, 0 - 9, or special symbols?
• Need to fill the range with values from Microsoft Excel custom lists, or your own lists?

The Random Number Generator for Microsoft Excel can do all this and more with ease! See the complete list of random value types that Random Number Generator can generate.

A really fascinating feature about Random Generator for Excel is that it is so intuitive that you will hardly ever need to look in Help, so easy-to-use that you will never need more than a tick and a click to have the range filled with random values, and besides that very fast, reliable and flawless.

What you can do with Random Generator for Excel

The Random Generator window has 6 groups, each of the tabs is designed for producing a particular type of random values. Below is a quick overview of their capabilities:

• Random numbers: integers, real numbers dates and boolean
• Random values from Microsoft Excel custom lists
• Random strings (passwords, codes)

1. Random numbers: integers, real numbers, dates and boolean

The first 4 groups are purposed for generating numbers exactly as their names suggest. They can produce:

• random integers
• random real numbers
• random dates
• random Booleans

You specify the minimum and maximum values and click Generate and you have the range populated. If you need unique random numbers or dates, check the Unique values checkbox in the corresponding group.

See online help for step-by-step instructions: Fill the range with random numbers.

2. Random values from Microsoft Excel custom lists

The next group is meant for populating the range with values from standard Microsoft Excel custom list(s) or from your own list.

Populate the range with values from your custom lists

You can select the entire custom list or several lists, or pick only some particular values you need. Then you click Generate and your selected range is filled with random values from the list(s). See online help for step-by-step instructions: How to populate the range with random values from a custom list.

Create worksheets from custom lists

The add-in allows creating worksheets with the names of all custom list values by clicking just one button. So if in your workbook you need the worksheets with the days of the week, just select the appropriate custom list and click Create worksheets.

Pick a certain number or percentage of values from a custom list

If you need to randomly select a given percentage of values from your custom list, the Random Number Generator for Excel can help with this as well. For example, you have 50 telephone numbers and you need to pick random 10. You add all 50 numbers to your custom list, select 10 blank cells in Excel, click Generate and voila - you have 10 random phone numbers from your list. You can find detailed instructions here: How to pick a given number of random values from a custom list .

Create a new custom list and have it added to standard Excel custom lists

Another great feature is the ability to add your custom lists not only to the Random Number Generator for Excel, but to the Standard Microsoft Excel custom lists as well. Suppose you have a list of names in a worksheet. You select that list, and click New List. That's it! Just one click and you have a new list added to the Random Generator. Now you also have it among your Microsoft Excel custom lists. To make sure, go to Microsoft Excel menu - > Tools -> Options -> Custom lists. You can find step-by-step instructions and tips here: How to create your own custom list.

3. Random strings - excellent password and GUID generator

And here is how the String group looks like:

Ideal password generator

You select the character set (you can choose one or several sets, e.g. A - Z, a - z and 0 - 9, or enter any other characters in the Custom field) and set the string length which may be up to 99 characters. Click Generate, and the Random Generator for Excel does the job in seconds. You can use this function as an ideal password generator. The AbleBits staff used this option to generate their e-mail passwords, and none has been cracked so far :-). See more tips here: How to generate strings of a given length.

Generate strings of any pattern – perfect code generator

A really unique feature of our Random Number Generator for Excel, that you will not find in any other add-in is generating random strings by mask. You use the mask when you need the string of a particular pattern. E.g. if you need to generate a number of GUIDs, you check the Hexadecimal character set and use this mask ????????-????-????-????????????. Click Generate and you will have the 6F9619FF-8B86-D011-B42D-00CF4FC964FF pattern all across the selected range. Of course, apart from GUID codes, you can use this option for producing any other code types, for example coupon codes, RGB color codes, product codes, zip codes, SKU codes etc. Find step-by-step instructions here: How to generate random strings by mask.

Very simple, isn't it? To make sure, just download the Random Generator for Microsoft Excel now and see for yourself :)
Download Random Generator for Excel, a fully-functional 15-day evaluation version.

Complete list of random values that Random Number Generator for Excel can produce:

• Random integers
• Random real numbers
• Random dates
• Random strings
• Random Boolean
• Random values from Microsoft Excel custom lists

Random Number Generator for Excel algorithm:

Our Random generator add-in uses the reliable Mersenne Twister algorithm. We use version MT19937 that produces a sequence of 32-bit integers and has the following advantages:

• It generates a better pseudo-random number sequence than the RAND() formula in Excel and the rnd() function in VBA.
• It has a very large period of a nonrecurring random number sequence: 2^19937 - 1.
• It has gone through numerous tests on statistical randomness, including the NIST Statistical Test Suite and Diehard tests. It passed most of, though not all, TestU01 Crush randomness tests, which are even tougher.

Download now and see how it can help you