如何判断内容是否一致？

cnmlgb9998 · 发表于 2024-4-17 10:16

=IF(SUM(MAP(SORT(TEXTSPLIT(C2,",",,TRUE),,1,TRUE),SORT(TEXTSPLIT(D2,",",,TRUE),,1,TRUE),LAMBDA(x,y,IF(x=y,0,1))))=0,"一样","不一样")

复制代码

首先，你要把单元格转换为文本型！！！！

是否随缘 · 发表于 2024-4-17 11:41

=IFERROR(AND(IFERROR(FIND(TEXTSPLIT(D5,","),C5),FIND(TEXTSPLIT(FIXED(D5,0),","),FIXED(C5,0)))),FALSE)

swl4561255 · 发表于 2024-4-18 11:31

=COUNT(FIND(MID(TEXT(D2,"0##,###,###;;;@")&",",(LEN(TEXT(D2,"0##,###,###;;;@"))+1)/3*{0;1;2}+1,(LEN(TEXT(D2,"0##,###,###;;;@"))+1)/3),TEXT(C2,"0##,###,###;;;@")&","))=3

复制代码

17601211544 · 发表于 2024-4-19 16:36

solextrade 发表于 2024-4-17 09:52
就题
=IF(COUNT(0/FREQUENCY(--MID(SUBSTITUTE(TEXT(C2:D2,"0,000,000"),",",REPT(" ",9)),{1;9;19},9),RO ...

大神，来搞定它吧

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

[已解决] 如何判断内容是否一致？