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*
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!
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.
Once it's randomized you should be able to just delete the "Random" column if you won't need to randomize it again. Or you could copy the column and go to "Paste Special >> Values Only" if you want to preserve the numeric values without them changing.
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!!!*
Thank you for being so clear and concise. You made it very easy.
Simple and to the point. Thanks man.
That's nice, I have been working with excel for years so i knew exactly what you were going to do from the start!
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*
I was using the 2007 version. Mileage may vary.
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!
Thanks man! Much appreciated!
Thanks. This helped me figure out a similar way in Google Docs.
This is exactly what I needed. Thanks!
Thanks. That was perfect.
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.
Thanks, that was simple
Great idea! Thanks.
THANK YOU SO MUCH.
Thank you! I used this to random group my students. ❤
Great idea!
Thanks a lot
How did you fill in the rest of the columns? That part is unclear and I can't get it to work?
cool work around bro.
Thank you.
Very interesting technique. Hope they create a function for this
Ridiculously smart!
thank you
Can you tell me how to stop the numbers from being randomised again after writing something in the same row/column please
Once it's randomized you should be able to just delete the "Random" column if you won't need to randomize it again. Or you could copy the column and go to "Paste Special >> Values Only" if you want to preserve the numeric values without them changing.
Thanks
Also I'm the 69th likes
hello 👋🤗