Randomize a List in Excel Using RANDBETWEEN Function

Published on March 10, 2017

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 EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE

Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide for FREE!

Thank you for subscribing.

Something went wrong.

HUGE LIMITED TIME DISCOUNT ON THE BEST ADVANCED EXCEL COURSE ENROLL NOW!!
EXCEL PRINT TIPS
9 Excel Print Settings You Probably Don’t Know About
excel_look_professional
Making Excel Worksheets Look Professional – A Case Study
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
FREEZE PANES
Freeze Panes in Excel – The Complete Guide
HOW TO LEARN EXCEL
How to Learn Excel and Be a Spreadsheet Champion
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
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
Pivot Tables
How to Insert a Pivot Table in Excel – Pivot Table Basics
How To Convert Pivot Table Into Frequency Distribution
How to Convert Pivot Table into a Frequency Distribution in Excel

GET MY EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE

Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide 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!"