Random Generator for Microsoft Excel

Generate non-repeating numbers and dates at random

Random number generator for Excel

With Random Number Generator you can easily populate cells in your worksheet with random integers and real numbers. Benefit from this helpful tool if you need to fill the selected range with random dates or Booleans in Microsoft Excel 2010-2003.

Free Download
Free 15-day trial version, 11/6/2013

How to generate random integers

  1. Select a range that you want to fill with integers in your worksheet. Click on the arrows to expand the Integer section
  2. In the From and to fields, define the minimum and maximum integers. You can manually type in the required values. Or you can set the values by clicking the up and down arrows next to the From and to fields. Specify the minimum and maximum integer values
  3. If you need random values without repeats, tick the Unique values checkbox and all the generated numbers will be different. You can generate from -2147483648 to 2147483647 unique random integers. Check this option to generate unique integers
  4. Click on the Generate button Click this button to fill in the range to fill your range with random integers.

How to create random real numbers in Excel

  1. Expand the Real section on the Random Generator pane by clicking on the arrows next to the Real section. Expand the Real section by clicking on the arrows
  2. Set the minimum value in the From field and the maximum value in the to field. You can manually enter the required values. Or you can set the values by clicking the up and down arrows next to the From and to fields. Set the maximum and minimum real values in these fields You can generate from -99999999.9 to 99999999.9 random real numbers.
  3. If you need random real numbers without duplicates, tick the Unique values checkbox and all the generated values will be different. Tick the option to have only unique real numbers
  4. Click on the Generate button Click this button to fill in the range.

How to fill the range with dates at random

  1. In your worksheet select a range that you want to fill with dates. Expand the Date section on the Random Generator pane. Clicking on the arrows will expand the Date section
  2. Select the initial and final dates in the From and to fields.
  3. You can enter the values manually or use the built-in calendar. To use the calendar, click the down arrow next to the From or to field respectively. This arrow opens the built-in calendar
  4. You can get workdays and weekends generated separately. If you want to create only workdays, tick the Workday checkbox. Tick Workday to work only with Workdays If you want to fill the range with weekend days only, tick the Weekend checkbox. Check the Weekend option to fill the range with weekends only To generate weekends and workdays at the same time, tick both options. Get weekends and workdays by ticking both checkboxes
  5. If you need unique random dates, tick the Unique values checkbox and all the generated dates will be different. You can generate unique random dates from 01.01.1900 till 31.12.2100.
  6. Click on the Generate button Click this button to fill in the range to fill your range with random dates. If the generated values don't appear as dates, please change the format of the cells using the standard Excel Format Cells... option.

How to generate Yes/No or True/False Booleans

  1. Expand the Boolean section on the Random Generator pane by clicking on the arrows next to the Boolean section. Expand the Boolean section using these arrows
  2. To select a Boolean, click the down arrow next to the Value field and select the necessary value from the drop-down list. You can generate true/false or yes/no values. Choose Boolean from the drop-down list
  3. Click on the Generate button Click this button to fill in the range to fill your range with random Booleans.
  4. If you want to change the generated random values in the selected range, just press Generate again and these Booleans will be automatically replaced by new values.

See also

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.