how to create a taxonomy of sorts on Excel.

[dunndealpr]

Hi all. Using Microsoft Excel as part of the Office365 package on a Macbook Pro running Windows 10/Bootcamp.

I'm embarking on a hiphop music keyword research project. I am working on a list of every hiphop artist and group I can possibly think of. Once this list is completed I will use a keyword research tool to find all popular keywords for each artist and group. I need to create one Excel sheet that will store all this information.

I need at least three ways to sort this data: by artist location, by sub-genre (classic or new, for instance) and by group affiliation. For example, the artist Aceyalone is from California so his location would be California. His sub-genre is classic, and his group affiliation is Freestyle Fellowship.

How can I adjust this data so that the entire list of all artist can easily be viewed by any one of these data points? For example, if I wanted to summon up a list of all California artists.
Even better, what if I wanted to summon up a list according to two or more data points? For instance, all artists that are California and of the classic subgenre.

This is simple stuff for you guys I'm sure. But Excel has always eluded me.


Thank you in advance.

[6StringJazzer]

It's not that simple. A database is a better tool for this type of thing than Excel. Do you have Access?

It can be done in Excel. The way I would do it is to design it like a database, with each table on a different worksheet then use VBA to provide the desired joins and query functionality. It would be slower than Access.

I am sure that people can give you pointers--do you want guidance or do you want someone to do it for you? Your requirements are clear but very high level and not detailed enough to actually build this. It gets complicated if an artist has more than one group affiliation, for example.

[dunndealpr]

I see. I guess for now I'd appreciate some guidance and pointers. Based on that information I may certainly need someone to help me build this. Many artists do have more than one group affiliation, and more data points will definitely be added as time goes on.

[popipipo]

I have a database with names and adress with a search function.

Maybe you can change it a little bit for you purpose

[alansidman]

Here is a tutorial on data base design.

http://www.ntu.edu.sg/home/ehchua/pr...se_design.html

[6StringJazzer]

What data do you have right now? Do you have something you can share here?

[dunndealpr]

Thank you very much. This looks interesting.
So, for example, if you wanted to use this sheet to create a view of everyone with surname Rock who lives in AR, how would you do that?
Also, how could you create a view of everyone with surname Rock who does NOT live in AR?

[dunndealpr]

I have a database with names and adress with a search function.

Maybe you can change it a little bit for you purpose

Thank you very much. This looks interesting.
So, for example, if you wanted to use this sheet to create a view of everyone with surname Rock who lives in AR, how would you do that?
Also, how could you create a view of everyone with surname Rock who does NOT live in AR?

[dunndealpr]

What data do you have right now? Do you have something you can share here?

Right now I only have a list of artists, which I will have to sit down and categorize one by one myself to fit the three categories I currently have: location, subgenre and group affiliation.

I don't even actually have a list yet. I have a list of mp3s. The mp3 filenames have the artist names in them. So first I have to figure out how to convert a bunch of filenames into a text list.