I have made a Book Archive in Excel 2013 that has the data sorted like this.
Book's Owner ¦ Book Cover ¦ Book Name ¦ Author ¦ Edition ¦ Language ¦ Topic ¦ Index
Since those are technical books only sometimes they have multiple authors so I had the idea to write the authors separated by a comma in the same columns with the idea I could have put a filter to filter them individually, something like Filter Comma Delimited Excel Column.
But I understood it being impossible, so I decided to try another approach. I separated the Author column in 5 different columns and I merged the the header as a single one.
What I want to do now is to be able to filter it by the header with a drop down list with all the authors, but with the AutoFilter function in the criteria it only display the authors that appears on the first column.
How can I make excel extend the criteria to the whole range of cells?
I'll attach some pictures to make you understand better.