﻿ Generate random numbers in Excel 2010

# Random Generator for Microsoft Excel

## Generate non-repeating numbers and dates at random

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.

### How to generate random integers

1. Select a range that you want to fill with integers in your worksheet.
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.
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.
4. Click on the Generate button 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.
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. 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.
4. Click on the Generate button .

### 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.
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.
4. You can get workdays and weekends generated separately. If you want to create only workdays, tick the Workday checkbox. If you want to fill the range with weekend days only, tick the Weekend checkbox. To generate weekends and workdays at the same time, tick both options.
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 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.
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.
3. Click on the Generate button 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.