+ Reply to Thread
Results 1 to 4 of 4

Help with sorting songs into multiple playlists

  1. #1
    Registered User
    Join Date
    12-16-2014
    Location
    Berlin, Germany
    MS-Off Ver
    2013
    Posts
    2

    Help with sorting songs into multiple playlists

    Hi everyone.

    Could someone give me some directions on how to create a spreadsheet that fills automatically whenever I insert a character elsewhere in the spreadsheet to label a song? Here's a picture to clarify

    1.jpg


    This is what I have. It's a simple list that highlights the line when certain letters are typed. I have some sheets of songs and one called "Playlists". My idea (if possible) is to create a formula - or use any other tool that I'm unaware of - that automatically fills the Playlist sheet sorting the songs tagged with specific letters into specific columns. Using the example above, the playlist sheet should output two columns - A and L - and fill the lines below it with the title of the song in the highlighted line, just the title will do, no need for any other info. I'm quite sure this is doable in excel, I just don't know how.


    I'm using excel 2013. Is there a not-too-difficult way to do this?


    By the way sorry if this post is in the wrong section of the forum.

    edit: can you see the picture now? (sorry for this)
    Attached Images Attached Images
    Last edited by Pavement; 12-16-2014 at 06:06 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Help with sorting songs into multiple playlists

    Your picture isn't visible. Please attach a sample of your workbook so we can use your own data to work on possible solutions. Remember to remove or replace any sensitive info before uploading.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    12-16-2014
    Location
    Berlin, Germany
    MS-Off Ver
    2013
    Posts
    2

    Re: Help with sorting songs into multiple playlists

    Bump no response

  4. #4
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Help with sorting songs into multiple playlists

    Quote Originally Posted by Pavement View Post
    Bump no response
    Again, please attach a sample of your actual workbook so we don't need to re-create work you have already done.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help sorting DJ playlists to find most played songs please.
    By samteacher1 in forum Excel General
    Replies: 3
    Last Post: 01-08-2014, 11:10 AM
  2. Counting duration of songs
    By remixit in forum Excel General
    Replies: 2
    Last Post: 12-16-2010, 04:48 PM
  3. Sorting multiple items by multiple criteria
    By sflearn in forum Excel General
    Replies: 1
    Last Post: 05-17-2007, 11:17 PM
  4. Sorting Multiple Worksheets
    By ShellyB in forum Excel General
    Replies: 1
    Last Post: 11-09-2006, 06:56 AM
  5. [SOLVED] how do i do an alphabetical list of songs for a booklet
    By melodie in forum Excel General
    Replies: 6
    Last Post: 06-01-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1