Random Sort of Text Column in Apple Numbers

With Apple Numbers column of iTunes song names (e.g. Amazing Grace, America...Yesterdays, You Belong to Me) how do I sort the column in random order. Names beginning with same first letter can be together in column. I want to make 4 or 5 CDs from these 325+ .mp3 files for random playing. Result should be random selection of songs on CDs which songs are played at random from CD.

I also have access to MS Excel 2007.
Who is Participating?
Ejgil HedegaardConnect With a Mentor Commented:
You can use an extra column with a random sort number.
Attached sheet set a random number from 1 to 100 on each name, so every sort give a new list.
MARSPATHAuthor Commented:
Really wanted RANDBETWEEN(1,320) with no duplicates - however with added random play of 4 CDs, this will be OK.

Thanks for your help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.