• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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