Hello, you are welcome to view the Radio Mute music forum as our guest. If you wish to participate, you will have to register to become one of our members. Radio Mute is an all inclusive music forum which strives to include every topic related to music. If you choose to participate, new forums and features will open up to you; including an option of having 3 songs uploaded and shown in your posts for free, community section with general chat and more.

User Name 
Password

Search 
 at 


Page 2 of 2 < 1 2
 
Thread Tools Search this Thread
Old 12-09-2003, 12:02 PM   #11
spacemanspiff
Bene Cognitiva
 
spacemanspiff's Avatar
 
Join Date: Jan 2003
Location: Cognation
well, in excel what you could do is put the name of the songs all in one collumn, and put random numbers in the next column ( "=rand()" ). You'll want to have a number for every title. The columns should be the same length. And then what you do is highlight the two columns and go up on the menu to Data-sort-Sort by 2nd column. That will sort them totally randomly. However it won't make sure there are no repeat artist. If you were willing to have the list be psuedo random then you could break the list up into small ones, so that each list doesn't not have the same artist twice, and then you can randomize the small list seperatly and then bring them together to make the big list.

by the way the random numbers re randomize everytime you do something, so don't work if it looks like they change all the time. it still works.
__________________
"The more I hear about pop culture, the less I feel inclined to bother keeping up with it.."
-The Rev
[offline]   Quote  
Page 2 of 2 < 1 2




Thread Tools Search this Thread
Search this Thread:

Advanced Search






Page generated in 0.12388 seconds with 21 queries [Server Loads: 0.04 : 0.04 : 0.00]