•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter/search by words while excluding other words/combination of words
I was using Filter/Search/Isnumber/Regextest combos to filter only the cells that has the word "oil" for example. However, what to do if I wanna exclude all the cells that has "cooking oil" from my results?
(To give the context, I want to filter the customers that worked in petrol/oil industry only, but filtering using "oil" will include customers who sell/make cooking oil).
Thank you so much.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#oil
#cooking oil
#filtering
#filter
#search
#petrol
#exclude
#industry
#customers
#customers in oil industry
#isnumber
#regextest
#cells
#worked