Total Subscribers Receiving Our Weekly Excel Lessons



Create a Random List with Excel’s RAND Formula

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

What does it do?

Gives you a random number between 0 and 1

Formula breakdown:


What it means:

=RAND(Will automatically choose a random number between 0 and 1)

Excel is able to do a lot of things that most users are unaware of!  One thing that amazes me & I use almost daily is its ability to create random numbers for me!

But why would I even need random numbers?

Random numbers in Excel are great if you want to fill in a column with random values so you can create quick charts or just do any kind of random Excel analysis.

One of my best uses of the RAND function in Excel is to create random numbers for a raffle draw!

Thankfully this is very easy to do with Excel’s RAND formula!

I explain how you can do this below:



STEP 1: We need to enter the RAND function:



STEP 2: Do the same for the rest of the cells by dragging the RAND formula all the way down using the left mouse button.

Now we are able to get random numbers for all the entries without any bias!

I’m actually the winner in this case as I have the lowest value!


EXTRA TIP: Press the F9 button on your keyboard to refresh/update the RAND values until you get your desired result…with bias 🙂



Related Posts:

Getting the length of text with Excel’s LEN ... What does it do? Gives you the number of characters of the text Formula breakdown: =LEN(text) What it means: =LEN(text that you want to get the number of characters) There are ti...
How to Convert Formulas to Values   Have you ever had a scenario where you write a formula and just want to show the value output only and get rid of the formula? Here is an example of a formula:   Well I do ...
Evaluate Formulas Step By Step in Excel This is one of the coolest tricks I have seen in Excel, as there are countless times wherein I had a hard time understand formulas. Especially long and complex ones! Excel provides the way to evalu...
Cleaning Data with Excel’s TRIM Formula What does it do? Removes unneeded spaces in your text, except single spaces in between words Formula breakdown: =TRIM(text) What it means: =TRIM(text that you want extra spaces to be re...
Searching... Searching...

If so, join over 45,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis!

Click here to subscribe

Leave a Comment

Your email address will never be published. Required fields are marked with *