https://docs.google.com/spreadsheets...it?usp=sharing
I'm trying to use excel to compile statistics about a specific music artist's concert set lists. I've been using COUNTIF for most things (how many shows were played on a certain day of the week, total number of times a song was played, etc.) but I can't figure out a formula to tell me the first and last time a song was played.
I don't know if I have the spreadsheet set up to be most effective, so I'm also looking for any help about how I might improve my formatting. Let me know if there is a problem with posting the link above.
Bookmarks