Personal Excel Spreadsheet to Sort Music!!

Question

Hello,  I am a mobile DJ (event host) and I want to sort all my songs from all my CDs (about 150 CDs) and enter them into Excel to create a table like this:   1st column: song title, 2nd: artist, 3rd genre (rock, disco...), 4th: CD number where the desired song is located (easier for searching later! lol!)   It seems pretty simple, the problem is that I make compilations and several songs end up multiple times on different CDs (basically, the same song can be on 2 or 3 different CDs).   All my CDs are numbered, and in the 4th column "CD number," I will inevitably have multiple numbers for the same song from time to time!   The problem is that during my events, I have my laptop, and people come to ask me for songs. So when I sort by the "song title" or "artist" or "genre" columns, it works perfectly, but when I want to sort, for example, all the songs from CD number 10, if a song is on both CD 10 and 15, it won't sort it for me!   What can I do? Knowing that I'm not an "Excel pro"... lol!   Thank you...

Claude Claude · Answer

Sort by CD number and song!! --   Support the Committee for the Fight Against Text Language and Intentional Mistakes on the Internet

sexymiss · Answer

What? I didn't understand everything lol!

Claude Claude · Answer

If you want all the songs from CD number 10  you sort first by the CD number, second by the song.  Another solution, you set an automatic filter and on the CD column you select your CD number  --   Support the Committee for the fight against text language and deliberate mistakes on the Internet

sexymiss · Answer

I can't understand you! Whether the first criterion is the CD number or the song makes no difference, right?  Moreover, how do we deal with the automatic filters? lol! And anyway, if I have 2 CD numbers in the same cell, will it still sort them?  For your info, I only number the CDs, not the songs! lol! I just want to know on which CD(s) the song is!  I know, I'm not good at Excel and I partied all night, so take it easy on me this morning and please express yourself in French if possible! lol! Thanks!...

Claude Claude · Answer

The order of the criteria is essential.   Sorting by CD number/song is quite different from sorting song/CD number.   If you don't understand, try the manipulation first.  --   Support the Committee for the Fight Against Text Language and Deliberate Mistakes on the Internet

sexymiss · Answer

Basically, I need to do:  A B C D  cd number song title artist genre  Is that it???  But if I put (once again...) several cd numbers in column A for the same song, will it still sort them?  We'll get there... let's keep up the morale! lol!

Claude Claude · Answer

You cannot have multiple CD numbers for a line in your Excel file, otherwise it's the ...  For the filter, select your entire table (press ctrl + A), then choose the Data menu/Filter/AutoFilter.  It's within everyone's reach  --   Support the Committee to Fight Against SMS Language and Deliberate Mistakes on the Internet

sexymiss · Answer

Well, that's exactly THE PROBLEM!!!!!!   I have several CD numbers in one line!!!   So what should I do??? Here’s what I have so far:   simple example:  ........A......................B........................C.....................D   ..song title...........artist..................genre................CD No   .....YMCA..............village people.............Disco...............03 and 24    If I sort all my songs by title, author, or genre, no problem! but if I want to display all the songs from CD 24 for example, well since CD 03 also has "YMCA," it bugs....

Claude Claude · Answer

You would need as many lines as you have couple/song CDs.  But the filter solution can satisfy you, since once you have applied the filter, you can select a column by indicating for example "contains xx and YY".  In your example, you would specify for the CD column "contains 24". Please try it.  --   Support the Committee against SMS language and intentional mistakes on the Internet

sexymiss · Answer

What do you mean by "song/CD couple"? I don't want multiple lines for the same song! Otherwise, the table will have almost double the lines! lol!   I don't have the file right now, I'm at work! But I'll try this evening! lol!    Any other solutions possibly?

Claude Claude · Answer

If you don't want multiple lines for the same song, stay in the current configuration. Try the filter after work and let me know. Biz  --   Support the Committee to Fight Against Text Language and Intentional Mistakes on the Internet.

sexymiss · Answer

Ok thanks a lot! @+ kisses... lol!

sexymiss · Answer

It's me again!  During the break, a colleague gave me part of the solution!!!  I'm doing:  .....A.....................B..................C..........................D...........................E.........................F................etc....  song title.........artist............genre...........cd number 1 (01 to 10).......cd number 2 (11 to 20)........cd number 3 (21 to 30)....etc...  ....YMCA.........village people .......disco.........................03.........................12.......................22  roxanne...............police.............rock.....................................................12.......................23  But the problem is, if I have "ymca" on cds 12 and 14, then it doesn't work...  We tried with "dummy" data, it doesn't work with the auto filters!

Vaucluse · Answer

Hello I'm providing you with a sample file linked below that allows you to find the list of titles and related information by

Claude Claude · Answer

Look at the attached model with the filter https://www.cjoint.com/?mFlxKmUk2J  Go to column D, click on the arrow, select "custom", then choose "contains" and in value put 4 for CD n°4   --   Support the Committee to fight against text language and intentional mistakes on the Internet

sexymiss · Answer

Wow! lol! This is exactly what I was looking for!!!  For the 7 columns, we can forget the rankings by tens (1 to 10, etc...) and just put the CD number (e.g., 7 in the first column and 9 in the second column), it's not a problem, on the contrary, so I think there won't be more than 4 (or even 5, but that's not certain) columns! lol!  However, how do you sort by title or author? Everything is "frozen" there! lol  And if I want to add songs, so rows?

sexymiss · Answer

Claude Claude  there's a good start but it's much more complicated and we have to redo all the filters every time!  Vaucluse  Nice table! lol! So how do we modify it???.....

Claude Claude · Answer

Who are you responding to? --   Support the committee fighting against text language and intentional mistakes on the Internet.

sexymiss · Answer

Claude Claude: I'm answering both! lol  But what I was looking for is VAUCLUSE who found it!!! lol!  But how do we modify.......?

Vaucluse · Answer

It might be a bit challenging for a novice, but we'll get there.  I can redo a reference file if you tell me:  _How many titles you have in the rows (we can easily go up to 65,000, but it's better to limit ourselves to what's necessary) _How many columns you use for your information (Title, Author's name, etc...) _How you want to display the results _If you want to display other options in the same way  If you want to see what's happening in the file, you can remove the protection: Tool / Protection / Unprotect Sheet Select columns K to R, Format / Column / Show and then you will be able to see the system  In any case, we can stick to 7 columns for the CD numbers, it doesn’t cost anything and who can do more can do less! I will create a clean file with all your information and the manipulations on a hidden sheet so you won't have any issues using it. I will include explanations so you can find your way. Once you have the right key, it's not very complicated.  BCRDLMNT PS: I won't be able to do this tonight, but probably at the very beginning of next year....!--  Science without conscience is but the ruin of the soul

sexymiss · Answer

Well... about 150 CDs, if you count about 20 songs per CD, that makes... 150*20= 3000. But to have some margin, count 5000! lol!  As for the columns:  1st: song title 2nd: artist 3rd: genre 4th to 10th: CD numbers where the songs are.  What I'm looking for is to be able to sort at any time and thus display the songs by title, by author, by genre.  And also to be able to search for a CD and display what's on it as you did (title/author/genre).  There you go, I hope I was able to inform you as best as possible and thank you so much for this service!...

sexymiss · Answer

Ok thanks! On the file you sent me, I can modify the data "titles, author, etc...  However, I can't get the function to accept other lines! I created new lines but the search doesn't include them...  Anyway, I’ll let you work on it! lol!  Searching by title is important! If someone asks me for a specific song, I type it in, and boom! it displays the CD where it is! ;-)  Here's my hotmail address to send me the "final" file lol! djlyonol@hotmail.fr  Happy New Year and thank you so much!!!!  Big kisses and see you next year!!! lol!

sexymiss · Answer

To be more precise, if someone asks me for a song, I type it in and I have the right CD! For the artist, it's the same! You give me a name and it shows me what I have from them, as well as the CDs where the songs are. If someone asks me for rock, I filter by genre on "rock" and voilà! It displays all I have in rock, and then if I want to look up what's on a specific CD, I enter the CD number and it shows me everything that's on the CD!  There you go! That's all I want! lol! If you can do that, you're awesome!!! lol!  Kisses and see you soon...

Vaucluse · Answer

We're good for nothing, but capable of anything... The only problem that will remain, I think, will be entering the title of the song without any mistakes, as Excel won't find its way back. See you later, I’m getting to work --  Science without conscience is but the ruin of the soul

eriiic · Answer

Good evening everyone,  Vaucluse, don't be mad at me for suggesting something... ;-) But since I had something equivalent that just needed tweaking and seems quite appropriate, I'm going for it.  The advantage is that the list updates as you type, so you just need to enter the characters you're sure of and fill in progressively.  So on this sheet, either use the dropdown lists in line 1, or start typing in one of the text boxes and the list updates dynamically. For example, type "ch" in the titles, and all those containing "ch" will be filtered. Type "rock" in genre (or just "ro" if there’s no other genre with "ro") and you get the rocks that have "ch" in the title, etc. The same goes for the other input areas, the criteria accumulate.  To retrieve the complete list, clear the 4 text boxes, and set the dropdowns to (all) if they were used. At the very least, we could add a button to reset this. http://www.cijoint.fr/cij118362814136408.xls  Happy New Year everyone Eric

Vaucluse · Answer

I certainly don't hold it against you, Eric, quite the opposite, I will take a close interest in what you propose because it is undoubtedly a formula just as interesting as mine.  But since I have finished my copy, I also make it available so that Seximiss can find it in the chimney with her New Year's Santa. She can play around with both. (I didn't put on a pink ribbon, sorry)  For Seximiss, if you want to use this file: manipulate a bit based on the data entered, knowing that you can enter 5000 on the INPUT sheet, and come back to us if there is a problem. Possible entries up to line 5000 List by CD number: Up to 50 List by author and genre: up to 300 List by title: of course, one title To expand, no problem, we will explain.  The other sheets for research are untouchable without removing protection, only the choice cells are accessible. In relation to what Eric says and which I will surely benefit from, is that my solution does not support discrepancies in labels in the entries to be searched. I think that for the rest it should be more or less the same in results, but I will look into that with interest....next year given the late hour this year. Best regards to both of you and Happy New Year.  Finally, take the time to copy the sample files, both Eric's and mine before manipulating them.  BCRDLMNT  http://www.cijoint.fr/cij117696386036424.xls --  Science without conscience is but the ruin of the soul.

eriiic · Answer

Since I had some time, a version with a fixed bug and the reset button. For the CD numbers, write them between two dashes: -xxx-  http://www.cijoint.fr/cij25823686436442.xls eric

eriiic · Answer

Hello Vaucluse and Miss,   No Vaucluse, no formula for me this time :-) Just a few lines in VBA that greatly simplify the use of filters.  I looked at your file. Your approach is original, but it's true that using formulas doesn't simplify the solution.  I'm taking this opportunity to upload a new copy with column D in text format to avoid any issues with entering the CD numbers.  http://www.cijoint.fr/cij82048126001.xls   Eric

Personal Excel Spreadsheet to Sort Music!!

28 answers

How to contact to have someone online

Get office for free

Arabic qwerty keyboard

Keyboard keys misalignment issue

Iphone apple 6s creating an apple id problem

Hacked facebook contact

Vpn port udp tcp

Toshiba tv menu unavailable

My samsung a32 keyboard no longer appears

Cannot connect to wi-fi