Randomize File Order
Open up the spreadsheet you want to randomize. Now, create a new column next to the names or any other column or row you want to randomize. If you have just a single column or row in the spreadsheet, then you don't need to perform this step.In the first cell of the new column, type in the RAND formula of '=RAND' (without the quotation marks).You now will need to copy the code and paste it down along the area you want to randomize. You don't need to type the same information throughout (which can be a major hassle if you have hundreds of cells you need to randomize). Instead, double-click the fill handle.Now, you can sort the column to randomize the information displayed. You can do this by clicking on the 'Home' tab and then choosing 'Editing Group.' From there, you'll want to choose 'Sort & Filter.'
A series of options will appear through a pop-up menu. This includes 'Sort Smallest to Largest,' 'Sort Largest to Smallest,' and 'Custom Sort.' Which allows you to adjust how you sort the information.You can also sort by clicking the 'Data' tab, then choose 'Sort & Filter,' and select the ZA button (or click it back to go AZ).One of the benefits of using the RAND function is that every single time you enter the information you will be given a different result. RAND will set different number functions to each of the current cells containing information. As each cell has randomly generated numbers (which Excel is then able to sort through based on largest or smallest), you can return to the RAND formula and continually click the 'Sort' button and you will receive new results every time. In order to set up the shuffle click the 'Ablebits Tool' tab, and then select 'Utilities.'
From there you'll want to select the 'Randomize' button. This will bring up two options. The first is 'Shuffle Cells,' and the second is 'Select Randomly.' For this purpose you'll want to choose the 'Shuffle Cells.'
The shuffle information will load on the left side of your application screen. You will be given a handful of options for how you want to shuffle the information. The methods for shuffling are as follows. It is highly recommended to save your spreadsheet before you continue with this. This is because when you begin to randomize some information, it may only randomize certain rows or certain columns. When this happens, it is breaking up sections of information you might want to keep together, such as a full row.So, save your work and then, when you randomize the information, save it as a different file. This way, you always have a fallback document should you find some information is no longer in the correct locations.
It is easy to go kind of crazy with the shuffle feature. You might select the shuffle feature once and then click it again and again and again. You will receive different results every time, but you might also be throwing the rest of your spreadsheet out of whack. The RAND shuffle option is the best at avoiding this problem; but even then you want to shuffle information and then check the details after the first shuffle.By looking at the information after the first shuffle you can see whether all the information you need to remain together stayed together. After all, if you are shuffling student names as a teacher, you don't want to accidently connect the grades of a different child, or combine last names. Attempting to undo this is a bit of a nightmare.Instead, you want to save before you perform the shuffle, then check to see what happened with the information following the shuffle. As long as everything remained locked together as it should, you can continue with future shuffles; but again, save the file as a different file just in case you need to go back to the original document.
There might be times where you are using the shuffle features and you just want to shuffle an individual row or column. Attempting to click and drag over the desired areas can get messy (and you may accidently move one number over to another cell without even knowing what you did). In order to make sure you have a nice and neat selection, it is better to use a keyboard shortcut.First, click on the first set of a sequences you want to select. Now, hold down the CTRL and the SHIFT key. From there, use the arrow keypads in order to select the area you want have highlighted. This way you won't be clicking around areas and risk moving data.Another way to perform this is to select the cell you want to begin with, then hold down the CTRL and the SHIFT button, then push the '.' button.
This will bring up the ability to type in the data set points for what you want to select.
Shuffle Files In A Folder
Random file orderOriginaly from sourceforge user.Added some funtionality and fixed some bugs.This version numbers the files in a sequential order instead of completely random like the original version. This makes it great to make a cd with a random track order. DescriptionIf, like me, you have a car radio or a clock radio which cannot play tracks in random order from your usb stick itself, this application might be useful for you.It randomly numbers every selected file in a specified folder.
So all you've got to do when you want a new play order for your music tracks is run this application.Also usefull for ordering numbers for a cd. Using you can then also easely add the track number in the tag info. Original project.