Posted: March 26, 2014

PROBLEM: Generating random numbers.

SOLUTION: Let Excel do it for you!



Excel – Using the RAND function

Below is an example of how RAND can be used.  Tracy has been asked to organise the order of speakers for her club speech competitions.  To ensure the order is done fairly she decides to use the RAND() function to return a random number for each competitor.


She then selects cells B2 to B11 and uses Copy, Paste Values to replace the function with real values.  Once she has done this she then uses the random number to sort the competitors into the order they will be speaking (lowest number goes first).

Note: RAND creates random numbers greater than and equal to 0 and less than 1.

Was this blog helpful? Let us know in the Comments below.

If you enjoyed this post check out the related posts below.

Join our free insiders Group!

Learn how to SAVE TIME and WORK SMARTER, without the 'techie' speak!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Join our free insiders club! 

Receive 100+ Steps to Becoming Proficient in Excel