0

I have a table with a column of tags, which is comma-separated and could be single or multiple text, eg "single", "not single". I also have a separate table that contains tags that I want to filter.

I have tried a combination of filter, regex and join formulas, eg =filter(data, regexmatch(some range, join some contents of filter strings) but they don't work and I am lost.

Help. Thanks and much appreciated.

Example (simplified for illustration):

TAGS - could just be a column in a sheet

random, words of, no meaning

random

words of

no meaning

FILTER WORDS - in a separate sheet but could grow

random

words of

IDEAL RESULT - in a separate sheet using filter formula

random, words of, no meaning

random

2
  • Sorry for the textual way. Could be confusing. If there's a better way to represent tables here, I, a noobie, need help.
    – gio888
    Jul 4 '21 at 1:50
  • Welcome to Web Applications Stack Exchange. Consider sharing a publicly editable sample spreadsheet with realistic-looking data, and showing your hand-entered expected results there. Jul 4 '21 at 9:44
0

Assuming that the tags are in column A2:A, and the filter words are in F2:F, try using regexmatch() with textjoin() like this:

=filter( A2:A, regexmatch(A2:A, textjoin("|", true, F2:F)) )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy