•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Automatically assigning music genres to artists based on existing entries
Our take
Managing a vast music library can be challenging, especially when it comes to categorizing songs by genre. If you have a spreadsheet filled with thousands of songs and want to streamline your process, automating genre assignment in Excel 365 is a practical solution. By leveraging existing entries, you can create a formula that automatically fills the genre cell based on the artist name you input.
I have a spreadsheet with thousands of songs. Columns include Song Title, Artist, and Genre. Manually typing the genre for each new song is tedious. Is there a way to automate this so when I enter an artist name in a new row, Excel automatically fills the genre cell based on previous entries for that same artist? I have a mix of artists with one genre and some with multiple. Ideally, the formula would check the existing table data. Using Excel 365. What is the most efficient approach?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Any way to automate removal of older rows of data?I have a spreadsheet with 4 columns: first name, last name, score and date. I have people who are duplicated, some with the same date which I can easily remove with "remove duplicates" but I have examples where there are people with multiple rows from where they have taken a test a few years later, and i am trying to find a way to optimise my chopping up of this spreadsheet to only have a single row per user, and showing only their most recent score for the test. The date column is dd/mm/yyyy and then a 24 hour format time stamp and I can't think of a good way to optimise that as it covers multiple years. Theres no good consistency over the old date and the most recent date I imagine excel has some way of pruning older data. Atleast I hope so or ill have to check 50000+ rows manually to remove old results 😭 submitted by /u/Skellyhell2 [link] [comments]
- Creating an automated excel sheetI want to create an excel sheet for balance sheets in which I type in one format and it automatically gets converted into another format as per the Act. I had trouble explaining it to chat gpt. Can anyone please recommend the prompt for Ai or recommend any tools that I can use myself for this automation. Also I can't use simple formulas as with every new balance sheet there is a little change in contents. submitted by /u/Total-Blueberry-4986 [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]