•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
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel
#filter function
#book quotes
#keyword
#merge list
#word search
#multiple lines
#shift in quote
#information
#Kvothe
#quote display
#complexity
#data sorting
#search functionality
#library