Solved

Random Sort of Text Column in Apple Numbers

Posted on 2016-08-04
2
77 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
2 Comments
 
LVL 21

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
highlight duplicate entry 16 26
DBF to ... Converter 5 27
Formula or Macro to determine variance 17 75
Merging-Splitting-Multiple-Rows 33 40
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

948 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now