How to Randomize a List in Excel
HTML-код
- Опубликовано: 17 ноя 2020
- In this video, I show you how to randomize a list in a column in Excel. For this example, I entered my list in column A, then used the RANDBETWEEN function to generate random numbers in column B. I then sorted columns A & B in ascending order by column B to randomize the contents in column A.
The formula I used was =RANDBETWEEN(1,1000)
Don't forget to subscribe to my channel for more tutorials!
Check out my website at simplesoftwaretutorials.com
Video recorded using Screencast-O-Matic (www.screencast-o-matic.com)
Thanks for tuning in! Хобби
You are the best. Concise and direct. Thanks
thanks a lot. was looking for it for a long time.