•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