Generate unique random numbers, strings, and random sort - Random Generator for Microsoft Excel

Random Number Generator - generating random value, date, custom lists, random sorting

Random Generator for Microsoft® Excel®

For Microsoft Excel 2010, 2007, 2003, XP (2002), 2000.

Do you need random values in Microsoft Excel?

• Want to fill the range with random numbers: integers, real numbers, Boolean or dates? 
• Need unique random numbers? 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? 
• Want to sort randomly your data, e.g list of customers or telephone numbers? 
• Need to fill the range with values from Microsoft Excel custom lists, or your own lists?
• Want to randomly select the needed number or percentage of rows from the list?

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 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 fill the range with random values, and besides that fast and reliable. Look at the screenshots below to see how easily you can generate random numbers.

How Random Generator for Excel works

As you see, the Random Generator window has 5 tabs:

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

Random numbers: integers, real numbers, booleans and dates

We are now on the first tab, where you can generate random integers, real numbers, Boolean and dates.

You select minimum and maximum values, click the appropriate button and that's it, you have the range populated. If you need unique random numbers or dates, check the Unique values checkbox.

Random values from Microsoft Excel custom lists

The second tab is purposed for populating the range with values from standard Microsoft Excel custom list(s) or from your own list.

How to fill in the selected range with values from your custom list or lists 

You select the custom list, or click on the plus sign to expand and select only some values from the list, click Generate and your selected range is filled with random values from the custom list(s).

How to pick up 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 Generator can help with this as well. For example, you have 50 telephone numbers and you need to pick up 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.

Ho to create a new custom list and have it added to the Standard Microsoft Excel custom lists

Another great feature is that now you can add your custom lists not only to the Random Generator, but to the Standard Microsoft Excel custom lists as well. Look how it works. Say, you have a list of names in a Microsoft Excel worksheet. You select that list, and click Add. That's it! Just one click and you have a new list added to the Random Generator. And, you also have it among your Microsoft Excel custom lists. To make sure, go to Microsoft Excel menu - > Tools -> Options -> Custom lists.

Random strings - excellent password and GUID generator

And here is how the String tab 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 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 :-).

Generate strings of any pattern

A really unique feature of our Random Generator, 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 6F9619FF-8B86-D011-B42D-00CF4FC964FF pattern all across the selected range.

Random sort

The Random sort tab hardly needs any explanations. You check one of the options, and Random Generator will mix the values in rows, columns or in the entire range, and put them in a random order. Or, you can choose to randomly sort entire rows or entire columns.

Random select

And finally, the "Random select" option. Imagine, you have a long list of names and you want to randomly select a certain number from the list. It takes no more than just a few seconds with our Random Generator. You select the whole list, switch to the "Select" tab and specify the needed percentage or the exact number of rows that you want to pick up. Click the "Select" button and voila, here you are.

Very simple, isn't it? Then download the Random Generator for Microsoft Excel right now and see for yourself.
Download Random Generator for Excel, a fully-functional 15-day evaluation version.

Complete list of value types that Random Generator can produce:

• Random integers
• Random real numbers
• Random dates
• Random strings
• Random Boolean And, rRandomly sorts cells in rows, columns and ranges as well as entire rows and columns Randomly select a given number or percentage of rows from the list
• Random values from Microsoft Excel custom lists
• And, randomly sorts cells in rows, columns and ranges

Random Generator algorithm:

Our Random generator add-in uses the reliable Mersenne Twister algorithm. We use the MT19937 version, which 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 the Excel and 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.

Random values generated using the Random Number Generator for Microsoft Excel

Random Number Generator for Microsoft Excel is compatible with

• Operating System: Microsoft® Windows 7 (x32, x64), Microsoft® Windows Vista® (x32, x64), Microsoft Windows® 2003, Windows XP, 2000.
• Microsoft Excel 2010 (x32), Excel 2007, Microsoft Excel 2003, Microsoft Excel XP, Microsoft Excel 2000.