I have a simple Excel spreadsheet consisting of a column containing song titles and adjacent columns recording dates of performance of each song (in date format). Some songs have only a few dates and some have many - all have been entered in sequence as they happen.
I would like to search for all the songs used in, say, 2017. ie. to filter all the date columns at the same time.
I tried Advanced filter but could not work out what to enter in the criteria field - everything I tried gave me an error message.
Can you help?
Bookmarks