I have a set of data. There is a case where I have to exclude some data from the data set. Here is the sample case:

CodePudding user response：

or:

=QUERY(A:A, "where not A matches '.*"&TEXTJOIN(".*|.*", 1, C:C)&".*'")