• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

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.
0
MARSPATH
Asked:
MARSPATH
1 Solution
 
Ejgil HedegaardCommented:
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.
Sort-playlist-random.xlsx
0
 
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.
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now