=LEN(CONCAT(A2:A37))
=TEXTJOIN(",",1,A2:A37)=TOCOL(TEXTSPLIT(C3,","))=SUBSTITUTE(B2,"你","睿姐")=MID(B2,FIND("，",B2)+1,99)
=LEFT(B2,LENB(B2)-LEN(B2))=REGEXREPLACE(B2,"[a-zA-z]","")=VLOOKUP("夜半清醒的*不忍苛责我",A:A,1,0)=LET(s,VLOOKUP("夜半清醒的*不忍苛责我",A:A,1,0),SUBSTITUTES(s,{"夜半清醒的","不忍苛责我"},""))
=IF(COUNTIF(A:A,"枫叶将故事染色结局看不透"),"包含","不包含")
=INDEX(A:A,MATCH("水向东流时间怎么偷",A:A,0)+1)=WRAPROWS(A2:A37,2)=TOCOL(WRAPROWS(A2:A37,2))=LET(s,CONCAT(A2:A37),CHAR(MODE(CODE(MID(s,SEQUENCE(LEN(s)),1)))))
=LET(_s,CONCAT(A2:A37),LEN(_s)-LEN(SUBSTITUTE(_s,"我","")))
=COUNTA(REGEXEXTRACT(CONCAT(A2:A37),"我",1))=LET(s,CONCAT(A2:A37),r,CODE(MID(s,SEQUENCE(LEN(s)),1)),TEXTJOIN("，",1,CHAR(TAKE(SORTBY(r,DROP(FREQUENCY(r,r),-1),-1),3))))
=INDEX(A:A,RIGHT(MAX(MMULT(1-ISERR(SEARCH(MID(C1,TRANSPOSE(ROW(INDIRECT("1:"&LEN(C1)))),1),$A$2:$A$37)),ROW(INDIRECT("1:"&LEN(C1)))^0)/1%%+ROW($2:$37)),3))=),1),A2:A37),COUNT),-1)扩展阅读
