英文:
Formulae to search for 12 and 13 in a range
问题
使用公式：
=LET(data,transpose(filter('Arbor Feed Tutor List'!A:A,(SEARCH("13", 'Arbor Feed Tutor List'!A:A))) ),
IFNA(REDUCE(TOROW(,1),SEQUENCE(COLUMNS(data)),LAMBDA(a,i,HSTACK(a,INDEX(data,,i),"HP's",INDEX(data,,i),INDIRECT(ADDRESS(ROW(), COLUMN()+1)))))))
来搜索包含文本"13"的单元格如何修改以搜索包含文本"13"或"12"的单元格尝试使用OR函数，但没有成功尝试过：
=LET(data,transpose(filter('Arbor Feed Tutor List'!A:A,(SEARCH(OR("13", "12"), 'Arbor Feed Tutor List'!A:A))) ),
IFNA(REDUCE(TOROW(,1),SEQUENCE(COLUMNS(data)),LAMBDA(a,i,HSTACK(a,INDEX(data,,i),"HP's",INDEX(data,,i),INDIRECT(ADDRESS(ROW(), COLUMN()+1)))))))
<details><summary>英文:</summary>using formula:
=LET(data,transpose(filter('Arbor Feed Tutor List'!A:A,(SEARCH("13", 'Arbor Feed Tutor List'!A:A))) ),
IFNA(REDUCE(TOROW(,1),SEQUENCE(COLUMNS(data)),LAMBDA(a,i,HSTACK(a,INDEX(data,,i),"HP's",INDEX(data,,i),INDIRECT(ADDRESS(ROW(), COLUMN()+1)))))))
to search for cells which contain text "13" in themHow could I modify this to search for cells containing text "13" OR "12"Tried the obvious using an OR function, no joy.ThanksTried:=LET(data,transpose(filter('Arbor Feed Tutor List'!A:A,(SEARCH(OR("13, "12"), 'Arbor Feed Tutor List'!A:A))) ),IFNA(REDUCE(TOROW(,1),SEQUENCE(COLUMNS(data)),LAMBDA(a,i,HSTACK(a,INDEX(data,,i),"HP's",INDEX(data,,i),INDIRECT(ADDRESS(ROW(), COLUMN()+1)))))))</details># 答案1**得分**: 0尝试用以下内容替换 `SEARCH("13", 'Arbor Feed Tutor List'!A:A)`：```plaintextREGEXMATCH('Arbor Feed Tutor List'!A:A, "12|13")
如果字符串中找到了这些值中的任何一个，它将返回true。
英文:
Try replacing SEARCH("13", 'Arbor Feed Tutor List'!A:A with:
REGEXMATCH( 'Arbor Feed Tutor List'!A:A,"12|13")
It will return true if any of those values are found in the string
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论