Randomize a List in Excel Using RANDBETWEEN Function

Published on March 10, 2017
image_pdfimage_print

Randomize a List in Excel Using RANDBETWEEN Function

I am back with yet another excel tip. This one would be a short read, but hopefully would still be helpful.

Have you ever had a list and wished you could rearrange it in a way that it randomizes its different elements? Well, you can easily do this in excel with the help of its RANDBETWEEN function.

random

Click here to download the file with the help of which I’ll explain the process.

Once you have downloaded the file, just follow the steps below:

  • First, make sure the list is arranged properly in a single column in a worksheet (in our case it is Column A).
  • Then, find out how many elements does the list have. In the file, you can see we have a list of 700 words in alphabetical order.
  • Next, in the adjacent column (Column B in our case), type =RANDBETWEEN(1,Number of Elements). Pull the formula down to have it adjacent to all the elements of the list. This will generate random numbers in the different cells of Column B.
  • Select all the results in Column B, press Ctrl C to copy them, and Ctrl Alt V to open the Paste Special dialogue box. Then select ‘Value’ and press Enter. This will replace the formulas with values. If we do not value-paste the random numbers they will keep changing after every action.
  • Press Alt A T to apply filter.
  • Sort the values in any order (ascending or descending). Your list will now be randomized. You can delete the values in Column B now.

I hope you enjoyed the above tip. To get updated with all my posts and to get additional excel tips, I encourage you to subscribe to our Facebook Page and join our 3300 followers. I share some really great content there, not just from Mad About Excel, but from other excel websites and blogs as well. Click below to subscribe.

Facebook_Mad_Mad_Excel

See you soon. Happy Excelling!

Get my ULTIMATE EXCEL SHORTCUTS COURSE
worth $40 for FREE!!

Subscribe to our newsletter and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

Huge Discount on the Best ADVANCED EXCEL Course. GET IT NOW!! CLICK HERE!!
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
BECOME AN EXCEL NINJA COMPLETE REVIEW
Become An Excel Ninja – Course Review
BEST EXCEL COURSES
10 Best Online Courses to Make You an Excel Wizard
HOW TO GET MY $40 COURSE FOR FREE
Get My $40 Excel Course For Free!! COUPON CODE Inside!!
14 Excel tips
14 Excel Tips – Make Yourself Super-Efficient in Excel
DATA CLEANING EXCEL
Ultimate Guide to Data Cleaning in Excel – 11 Super-Powerful Data Cleaning Techniques
RANDOMIZE LIST RANDBETWEEN
Randomize a List in Excel Using RANDBETWEEN Function
HOW TO FIND IF A TEXT STRING CONTAINS SPECIFIC TEXT IN EXCEL
How to Find if a Text String Contains Specific Text in Excel
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
How to Sort Excel Worksheet in Alphabetical Order
How to Sort Excel Worksheets in Alphabetical Order
VBAPOST1
How to Add And Name A New Sheet At The Same Time Using Excel VBA
ROUNDING NUMBERS IN EXCEL
Rounding Numbers in Excel – The Complete Guide
number_of_words
How to Find the Number of Words in a Text String in Excel
HOW TO FIND IF A TEXT STRING CONTAINS SPECIFIC TEXT IN EXCEL
How to Find if a Text String Contains Specific Text in Excel
How To Indentify ULP case in a text string
How To Identify If A Text String Is In Upper, Lower Or Proper Case
How To Change Shape of Comment Box in Excel
How To Change The Shape Of Comment Box In Excel
Excel Dumbest Challenge
Excel Dumb Challenge – Do You Have Time To Waste?

Get my ULTIMATE EXCEL SHORTCUTS COURSE
worth $40 for FREE!!

Thank you for subscribing.

Something went wrong.

Share
Tweet
+1
Pin
Share
Stumble
Enjoyed this video?
RANDOMIZE LIST RANDBETWEEN
"No Thanks. Please Close This Box!"