Solved

Random Sort of Text Column in Apple Numbers

Posted on 2016-08-04
2
165 Views
Last Modified: 2016-08-05
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
Comment
Question by:MARSPATH
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 41744342
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
 

Author Closing Comment

by:MARSPATH
ID: 41744889
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question