In this tutorial, Excel VBA show you three easy ways to quickly shuffle a list of names or items in Excel.
Randomize List Using SORT BY Formula
Presume you have a list of names, as shown below, and you want to randomize this list.
Below is the formula that will do this:
I have used the COUNTA function to get the total number of names in the list, which is then used within the RANDARRAY function to generate a list of 14 random numbers (as there are 14 names in the checklist).
This random list of 14 digits is then used within the SORT BY function to give us the shuffled list of names.
If you want to reshuffle this list, hit the F9 key, and the list will shuffle again (this happens because RANDARRAY is a volatile function and refreshes whenever you hit F9 or make a change in the Excel file).
Once you have the list of random names you want, you can convert the formula to values to don’t change again.
Randomize List Using RAND Formula + SORT Feature
If you don’t have access to the SORT BY and RANDARRAY function, you can randomize the list the old-fashioned way.
Below I again have the list of names that I like to shuffle and get a new list.
Here are the steps to do this:
- In the adjacent columns, enter the following formula: =RAND()
- Copy and paste the formula to all the adjacent cells in columns B
- Select the dataset (including names and the numbers in column B)
- Click the Data tab in the ribbon
- In the Sort and Filter group, click on the ‘Sort’ icon
6. Select ‘Random Number’ from the Sort by drop-down in the Sort dialog box.
Click OK
At this time it seems like Drupal is the best blogging platform out there right now. Antione Kubesh
The most effective man is often the grooms most reliable and faithful good friend or relative. Herbert Dalba
Make sure that each soccer goal is appropriately padded to help avoid head injuries should a player come in contact with the pole during a game. Von Flink
Excellent post. Keep posting such kind of info on your blog. Roman Nakahara
The sketch is tasteful, your authored material stylish. Suki Arnoldo Sayed
Amazing! Its truly amazing piece of writing, I have got much clear idea regarding from this paragraph. Grace Geoffry Orme
This is my first time pay a quick visit at here and i am actually pleassant to read all at alone place. Emelia Arman Grogan
There is certainly a great deal to find out about this subject. I love all of the points you have made. Rupert Eddins
Some truly nice stuff on this website , I like it. Stanley Munno
If some one wishes expert view regarding blogging and site-building then i advise him/her to go to see this blog, Keep up the good work. Laverne Shupe
Hi, I would like to subscribe for this weblog to obtain most recent updates, therefore where can i do it please assist. Alphonso Coup
Howdy! I know this is somewhat off-topic but I needed to ask. Deon Bow
You completed a number of nice points there. I did a search on the subject and found most persons will go along with with your blog. Leigh Mcqueary
Very revealing bless you, I do think your current audience might want a whole lot more content such as this continue the excellent work. Gregory Leonor
I visit everyday some sites and sites to read articles, but this blog presents feature based content. Isreal Bellhouse
A big thank you for your article. Really thank you! Much obliged. Denny Herl
Wow! At last I got a weblog from where I know how to truly obtain valuable data concerning my study and knowledge. Rolando Sterkenburg
Whats up very cool website!! Guy .. Beautiful .. Superb .. Roger Jarnigan
Thanks Neal! Great to see you and we will be posting info for our next Meetup soon. Elisha Molano
Those are so cute and a really great craft! I think a few of those around my backyard would be awesome. Rodney Vigueras
These are in fact enormous ideas in regarding blogging. You have touched some fastidious factors here. Any way keep up wrinting. Dominick Hertlein
Yes! Finall somethimg about 10 ays to lkve a healthy life. Dannie Amphy
Hi, just wanted to mention, I loved this blog post. Vince Declet
Watch Free Hd Pon Hot Porn Hd Pon Videos and Download it. Watch Free Hd Pon Video Hot Porn Hd Pon Video Videos and Download it. Lucius Verant
Some really excellent content on this website , appreciate it for contribution. Hugh Ozaeta
Hallo und vielen Dank. Dieser Blog ist eine wahre Inspiration. Erwin Means
Wonderful article! We will be linking to this particularly great article on our website. Keep up the good writing. Hobert Schandel
Card can be found and a bit more complicated than that. Kim Nykiel
Some genuinely prize posts on this internet site , saved to favorites . Garry Bobseine
Wonderful, what a website it is! This webpage presents valuable information to us, keep it up. Julian Sil
I seriously love your website.. Excellent colors & theme. Tyree Walles
I believe this presents really good reading material. You make the material interesting and entertaining. Marshall Medious
Goodd post. I learn something new and challenging on sites I stumblupon on a daily basis. Jude Darner
Hello, its good paragraph regarding media print, we all understand media is a fantastic source of information. Sam Gowens
You made some decent points there. I did a search on the issue and found most persons will approve with your website. Junior Norrix
There is noticeably a package to understand about this. I presume you made sure wonderful points in features also. Kristopher Tse
I visited multiple web pages but the audio feature for audio songs present at this web page is genuinely fabulous. Rudy Skobiak
Revisa la configuracion del reloj de cuanta atras y de la hora de inicio de la reunion. Nos esta funcionando correctamente. Scotty Bolding
Say, you got a nice article post. Really looking forward to read more. Really Cool. Adrian Thuman
Looking forward to reading more. Great blog article. Really looking forward to read more. Keep writing. Monty Vanhoy
I was examining some of your articles on this internet site and I think this website is really instructive! Retain putting up. Brock Staubs
We stumbled over here different web address and thought I should check things out. Gene Cabana
I have read so many posts on the topic of the blogger lovers but this article is genuinely a nice paragraph, keep it up. Cleo Ritchhart
Thanks for the article. Much thanks again. Much obliged. Patricia Schwalenberg
Thank you for your article. Much thanks again. Really Cool. Omer Frain
Thanks for sharing your thoughts on magazin pescuit. Randall Wiggen
Dead indited content , appreciate it for information . Ashley Angel
This article will assist the internet users for setting up new weblog or even a weblog from start to end. Hyman Overmeyer
Excellent article! We are linking to this great content on our site. Keep up the good writing. Antwan Spilman
If some one wishes expert view about blogging after that i propose him/her to go to see this website, Keep up the good work. Jimmie Ehrisman
Your way of describing the whole thing in this piece of writing is genuinely good, all be able to without difficulty know it, Thanks a lot. Giovanni Keesecker
Really appreciate you sharing this article. Really thank you! Want more. Nestor Hartsough