Generating random numbers in Excel

On Twitter this weekend, I found a cool link on how to generate random numbers in Excel. Considering I normally use a random number generator site to do this, I thought it was a pretty cool tip.

First, highlight the number of cells that matches the number of random numbers you want. In this example, I want to get three random numbers:

excel-randomnumbers-20180220-1

Next, type in the function =RANDBETWEEN(nn,nn), with the first number being the low range of the random numbers, and the second number being the high range. In my example, I want three random numbers between 2 and 250:

excel-randomnumbers-20180220-2

Once I have that typed in, I hold down the CTRL key and press ENTER. That will fill in my highlighted cells with random numbers between 2 and 250:

excel-randomnumbers-20180220-3

I encourage you to go out and read the article, as there are a few caveats to keep in mind, such as this method can and will generate duplicate numbers. There is another method he covers that’s a bit more complex, but it eliminates most of the duplicate number risk.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s