英文:
How to filter out cells that contain specific words?
问题
有没有一种方法可以使用“筛选”功能来过滤掉包含单词“_design”和“_obdm”的单元格？
英文:
Is there a way to use the "Filter" feature to filter out cells that contain the words "_design" and "_obdm"?
So that the cells that are left will be:
答案1
得分: 1
如果您希望通过公式来执行此操作，可以尝试以下公式：
=FILTER(A2:A10,BYROW(ISNUMBER(SEARCH({"Design","obdm"},A2:A10)),LAMBDA(x,NOT(OR(x))))
英文:
If you can wish to do it by formula then could try-
=FILTER(A2:A10,BYROW(ISNUMBER(SEARCH({"Design","obdm"},A2:A10)),LAMBDA(x,NOT(OR(x)))))
答案2
得分: 1
你可以将筛选器设置为文本筛选器，然后选择“文本不包含”并键入“design”和“obdm”。
激活筛选器后，您将获得
英文:
You can set the filter to text filter, then select "text does not contain" and type "design" and "obdm"
after activating the filter you will get
答案3
得分: 1
- 它将允许单个条件或一组条件（
REDUCE不关心）。
=LET(Data, A2:A9, Criteria, {"_design"; "_obdm"},
Ones, SEQUENCE(ROWS(Data),,,0),
cData, REDUCE(Ones, Criteria,
LAMBDA(Seq, Crit, Seq*ISERROR(SEARCH(Crit, Data)))),
FILTER(Data, cData))
英文:
Filter Column of Data (REDUCE)
- It will allow a single criterion or an array (range) of criteria (
REDUCEdoesn't care.).
=LET(Data,A2:A9,Criteria,{"_design";"_obdm"},
Ones,SEQUENCE(ROWS(Data),,,0),
cData,REDUCE(Ones,Criteria,
LAMBDA(Seq,Crit,Seq*ISERROR(SEARCH(Crit,Data)))),
FILTER(Data,cData))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论