Hello,
I have used Excel before, but mainly for basic money calculation purposes, and it was years ago.
I have the desire to create a spreadsheet that will, in the end, allow me to see the frequency of certain songs I've seen by a certain band (the same band).
I racked my brain all last night trying to figure out the best approach in creating such a spread sheet.
What I want to do is provide the date of a concert, and all of the songs played at that specific concert. I have that info. There are 78 concerts that I need to input. However, it seems redundant for me to list, for example, "Song A" if it was played on "date X", and then list "song A" again if was played on "date Y". This is where I'm not sure what makes the most sense.
Would it be better to use the A-Z axis and provide the 78 dates of concerts, and use the numbered axis to list all of the songs that were seen/heard. Then I could put some sort of check mark in the cell that corresponds to the song and date? (I'm confusing myself just typing this). This way seems like more work than is necessary.
If anyone out there has any insight, I would be grateful!
Greendad
Bookmarks