1 min readfrom 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

submitted by /u/ActAutomatic6726
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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
Filtering function for Column information