•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter function problem. Any thought?
Our take
Struggling with Excel's filter function can be frustrating, especially when managing a library of book quotes. You want to sort and search by keywords, but merging lists for multi-line quotes complicates things. The challenge lies in ensuring that related information appears when you search for a specific term, like "Kvothe." Fortunately, there are effective solutions that can streamline your process. Let's explore how to optimize your filtering technique so you can effortlessly access all relevant quotes and notes without the hassle.
New to excel and working on a library of book quotes, see example.
I need to be able sort by key word, if i merge the list of key word for each quote and input a word search filter it doesn't work since some quotes/notes have multiple lines. I need it so when i search a word that all information in regards to the related quote shows. note the left hand column indicates a shift in quote.
here is an example I want to see information about Kvothe. so all of these should show up.
This is beyond my ken. Maybe there is a simple answer or it's more complected then I think.
Thanks.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience