Alright, so I'm completely new to this forum, so please be patient.
I'll try to be as clear as possible, but I'm a musician and I keep track of my repertoire (along with how often I perform each song) through a spreadsheet I've generated. Down the first column I've listed the songs, and across the top row I've listed the dates. So, each time I perform a song, I insert a symbol into that cell that will corresponds to the date and song. At the end of each year, I use the 'COUNTIF' function to total up the # of times I've performed the song [example: =COUNTIF(B6:AX6, "●")]
Here's my issue: Right next to my 'Totals' column, I would like to be able to include a column that automatically generates the last date that each song was performed. Is this possible??
Bookmarks