•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter function problem. Any thought?
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]
Want to read more?
Check out the full article on the original site