求函数公式

jerry2022 · 发表于 2024-4-2 16:28

版本office2013，没有TEXTSPLIT函数，谢谢各位大佬

苏小亓 · 发表于 2024-4-2 16:39

附件在那里？

makin_mao · 发表于 2024-4-2 16:48

=iferror(if(a2=b2,"正确","错误"),"错误")

啸海 · 发表于 2024-4-2 16:53

本帖最后由啸海于 2024-4-2 16:58 编辑

=IF((COUNT(FIND(","&TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",99)),ROW($1:$9)*99-98,99))&",",","&A2&","))=LEN(A2)-LEN(SUBSTITUTE(A2,",",))+1)*(LEN(SUBSTITUTE(A2,",",))=LEN(SUBSTITUTE(B2,",",))),"正确","错误")

jerry2022 · 发表于 2024-4-2 17:00

makin_mao 发表于 2024-4-2 16:48
=iferror(if(a2=b2,"正确","错误"),"错误")

a2和b2对比的是里面的文本内容，单元格里面有逗号隔开，顺序不一样，但是文本内容是一样的

jerry2022 · 发表于 2024-4-2 17:58

啸海发表于 2024-4-2 16:53
=IF((COUNT(FIND(","&TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",99)),ROW($1:$9)*99-98,99))&",",","&A2&","))= ...

谢谢大佬，大佬威武

		自动登录	找回密码
密码			免费注册

[求助] 求函数公式