range
22.1234 to 79.1234
and from row 1 to row 300.
how to do it........?
Do you need to insert random numbers in Microsoft Excel? There are several methods to insert random numbers in a range as follows:
Insert random numbers by formulas
Insert random numbers with specified decimal places by VBA
Insert random integer numbers/dates/times without repeats/duplicates
Kutools for Excel's Insert Random Data utility enables to insert random integers (whole numbers) between two certain numbers easily, randomly insert a series of dates (only workdays, or only weekends, or no limitation) between two dates, randomly insert a series times between two times, or generate random text strings with certain length. And the Unique values option will prevent from inserting duplicates.
Full Feature Free Trial 60-day!
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
This method will apply the RAND function and RANDBETWEEN function to insert random numbers between two numbers into a specified range in Excel. Please view below formulas:
Formula | Description (Result) |
=RAND() | A random number between 0 and 1 (varies) |
=RAND()*100 | A random number between 0 and 100 (varies) |
=RANDBETWEEN(low, high) | A random integral number between two given integer numbers, such as RANDBETWEEN(50, 100). |
See below screenshots:
Random numbers between 0 and 1 =RAND() |
Random numbers between 0 and 100 =RAND()*100 |
Random integer numbers between 50 and 100 =RANDBETWEEN(50, 100) |
Below VBA can help you insert any random integer numbers or random numbers with given decimal places into a specified range in Excel. Please do as follows:
1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module window.
Public Function RandomNumbers(Num1 As Long, Num2 As Long, Optional Decimals As Integer) 'Update20131113 Application.Volatile Randomize If IsMissing(Decimals) Or Decimals = 0 Then RandomNumbers = Int((Num2 + 1 - Num1) * Rnd + Num1) Else RandomNumbers = Round((Num2 - Num1) * Rnd + Num1, Decimals) End If End Function
3. Save and close the code, then in a blank cell, input this formula =RandomNumbers(X,Y,Z), X indicates the lower limit of the numbers, Y indicates the higher limit of the numbers, and Z is the specified decimal places of random numbers.
For example, I want to generate some whole numbers between 50 and 1000, I can insert this formula =randomnumbers (50,1000,0); and insert random numbers between 50 and 100 with 2 decimal places with this formula =randomnumbers (50,100,2). See below screenshots:
Kutools for Excel's Insert Random Data makes it possible to insert random integral numbers between two numbers without duplicates into selected range in Excel. Please do as follows:
Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel |
1. Select the range you want to insert random integer numbers, and click Kutools > Insert > Insert Random Data, see screenshot:
2. In the Insert Random Data dialog box, (1) click Integer tab, (2) In the From and To boxes type the number range you will generate random whole numbers between, (3) check the Unique Values option, (4) and click the Ok button. See screenshot:
This fantastic Insert Random Data feature also supports to insert random dates without repeats, random time without duplicates, random characters, and random data from certain custom list without repeats as well.
Insert random dates (excluding weekends) without repeats by Kutools for Excel
Insert random time data without repeats by Kutools for Excel
Insert random characters with specified string length by Kutools for Excel
Insert random data from certain custom list without repeats by Kutools for Excel
In this Video, the Kutools tab and the Kutools Plus tab are added by Kutools for Excel. If need it, please click here to have a 60-day free trial without limitation!
Related article:
Generate random character strings in a range
Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.