Xcel – making a random list
Say you have a list of 100 words in alphabetical order, and you need them in random order.
This is how you do it…
Add a column next to your list and put this in those cells:
=Rand()
This will put random numbers next to your list. Then you can select both columns and sort in descending or ascending order on the cells with the random numbers. Everytime you do the sort, it should change the order because the numbers change on every new calculation in the sheet.
Why would you need this? For a first grade reading test of course!
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
This is how you do it… Add a column next to your list and put this in those cells: =Rand() This will put random numbers next to your list…..
..редко.. можно сказать, это исключение
…