•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filtering function for Column information
Hello all, I am currently running a the function below to filter out words in a specific column (changed words for simplicity). I was wondering if there were a function that can be added on to the function below so that any specific words would instead come back as other
=LET(
_keywords, {"APPLE","BANANA","GRAPES","PINEAPPLE"},
_text, TEXTSPLIT(A1, , " "),
_filter, FILTER(_text, BYROW(1 - ISERR(SEARCH(_keywords, _text)), OR)),
_joined, TEXTJOIN(" ", TRUE, _filter),
_joined)
EX. Column A1 says Apple basket with Banana bread, which gives me Apple, Banana
But what can I do so that when A2 says Cookie gift and Apple basket, it sends me back with Other, Apple
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#FILTER
#TEXTSPLIT
#TEXTJOIN
#LET
#keywords
#A1
#A2
#Apple
#Banana
#Grapes
#Pineapple
#SEARCH
#OR