How to Randomize a List In Excel

Very video quick tutorial on how to sort a column randomly in Excel

[AlitaMurray-ek]

Love that you made it brief and didn't add alot of extra commentary! Thanks

[doc-canada]

When learning something new, I use flash cards when possible. I was trying to come up with a method using my computer.
E.G. to learn a new language, one column has the English words and the second column has the foreign words. By changing the font colour or the cell colour of the foreign words column, you can make them invisible unless you select them, and then the word becomes visible in the fx window or you can change the cell colour or font colour to check. My concern was that with constant repetition, you can sometimes predict the next 'invisible' word. Your video provides the method needed to randomize the lists. Thank you so much.

[chaoticwisdom]

Thank you for being so clear and concise. You made it very easy.

[G-ShrishailyaRao]

okay wtf! why hasnt this been taught in my school! This is SOO easy. THIS IS SO Much easier than that RANDBETWEEN, RANK. EQ and COUNTIF functions word vomit that I had to learn! THANK YOU! You saved my Computers Practical Paper by posting this video!

[cristovieneya]

Thanks so much. So simple, yet so useful. I came looking for a way to randomize values on scatter chart and this just did the trick. *Awesome!!!*

[cradleofrelaxation]

That's nice, I have been working with excel for years so i knew exactly what you were going to do from the start!

[xbxlxexhx]

Thanks for the vid!
If you need the numbers to stay unchanged (i.e. stop calculating RNG every time you make a move), you can do so by going to
*Formulas -> Calculation Options -> Manual*
Also you can freeze the A column (if it's your "Numerical order", which you don't want to change) by going to
*View -> Window -> Freeze Panes -> Freeze First Column*
You can undo both of these by getting them back to *Auto* & *Unfreeze*

[TheCmanPLPro]

Thanks. This helped me figure out a similar way in Google Docs.

[josejorgeromero]

This is exactly what I needed. Thanks!

[kpviper]

How did you fill in the rest of the columns? That part is unclear and I can't get it to work?

[lemonwhite]

Thank you! I used this to random group my students. ❤

[petritcera]

Can you tell me how to stop the numbers from being randomised again after writing something in the same row/column please

[treasonouspigeonpeckers]

Very interesting technique. Hope they create a function for this

[le_prime]

Thanks

Also I'm the 69th likes