Random Generator for Microsoft Excel 2.0

Random Generator for Microsoft Excel 2.0 offers an effective tool which helps you to fill the selected range with unique random numbers, integers, real numbers, dates or strings; to generate strings with different character sets; to randomly sort values and do many other things.

Do you need one of the following?

1. Fill the range with random integers, real numbers, Boolean or dates?
2. Unique random numbers?
3. Random passwords of a certain length with different character sets, or with special symbols?
4. Sort randomly your data in rows, columns or range?
5. Fill the range with values from Microsoft Excel custom lists, or create your own custom lists?

You will need no more than a click to do all this stuff using the Random Generator.

The Random Generator add-in works for Microsoft Excel 2007, 2003, 2002 (XP) and 2000.

Major Features:

1. Random numbers: integers, real numbers, booleans and dates
   • Generate random integers, real numbers, Boolean and dates.
   • Random integers, real values, random dates, random booleans
   • 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.
2. 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.
   • How 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.
3. Random strings - excellent password and GUID generator
   • 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.
4. Random sort
   • And finally, the Random sort tab. It 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.
5. Complete list of value types that Random Generator can produce:
   • Random integers
   • Random real numbers
   • Random dates
   • Random strings
   • Random Boolean
   • Random values from Microsoft Excel custom lists
   • And, randomly sorts cells in rows, columns and ranges

Enhancements:

• ADDED: Unique values option for integers, real values, dates and custom lists.
• ADDED: Ability to fill the selected range with values from the custom lists in a random order.
  ADDED: Ability to generate random strings from a selected character(s) set.
  

Requirements:

• OS: Microsoft Windows Vista (x32, x64), Microsoft Windows 2003, Windows XP, 2000, ME
• Microsoft Excel 2007, Microsoft Excel 2003, Microsoft Excel XP, Microsoft Excel 2000.