Pinterest Pixel

Create a Random List with Excel’s RAND Formula

Bryan
What does it do?
Create a Random List with Excel's RAND Formula | MyExcelOnline Create a Random List with Excel's RAND Formula | MyExcelOnline

Gives you a random number between 0 and 1

Formula breakdown:

=RAND()

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:

Create a Random List with Excel's RAND Formula | MyExcelOnline

Download excel workbookRAND-FORMULA.xlsx

 

STEP 1: We need to enter the RAND function:

=RAND()

Create a Random List with Excel's RAND Formula

 

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!

Create a Random List with Excel's RAND Formula

 

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

 

 

 

If you like this Excel tip, please share it
Create a Random List with Excel's RAND Formula | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  OFFSET Function Introduced

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...