How to Generate Random Numbers In Excel | Dummy Records

Note: If video does not play,
just refresh page and then Play video or Just Click on this text.

There are two functions designed to generate random numbers in Excel: RAND and RANDBETWEEN.
The RANDBETWEEN function provides random numbers, but results are more likely to be repeated.
The RAND function is more likely to produce non-repeating results. However, there are only random numbers between 0 and 1. You can use this with RANK to generate unique random numbers in Excel (discussed later in this tutorial).
The Excel RANDBETWEEN function generates a series of random integers between two specified numbers.
The RANDBETWEEN function accepts two arguments, a lower bound and an upper bound. It just gives an integer between the two specified numbers.

For example, suppose I want to generate 10 random numbers between 1 and 100.

Here are the steps to generate random numbers using RANDBETWEEN:

• Select the cell in which you want to get the random numbers.
• In the active cell, enter =RANDBETWEEN(1,100).
• Hold the Control key and Press Enter.

This will instantly give 10 random numbers in the selected cells.

While RANDBETWEEN makes it easy to get integers between the specified numbers, there is a high chance of repetition in the result.

For example, when I use the RANDBETWEEN function to get 10 random numbers and use the formula =RANDBETWEEN(1,10), it gives me a couple of duplicates.

If you’re OK with duplicates, RANDBETWEEN is the easiest way to generate random numbers in Excel.