汉王刘启 发表于 2021-12-9 09:17:00

请教大佬，如何用公式查找两行的相同数，谢谢！

赵淼鑫 发表于 2021-12-31 16:39:23

C2数组公式：（下拉）
=IF(COUNT(FIND(","&FILTERXML("<a><b>"&SUBSTITUTE(B$2,",","</b><b>")&"</b></a>","//b")&",",","&A2&",")),"有",N(C1)+1)

开辟鸿蒙 发表于 2022-1-8 02:26:36

C2下拉
=IF(OR(MMULT(IFERROR(FIND(","&ROW($1:$99)&",",","&IF({1,0},A2,B$2)&",")^0,),{1;1})=2),"有",N(C1)+1)

兵娃子 发表于 2022-2-10 03:20:42

哈哈哈，换着来

钱晓东 发表于 2022-2-10 05:50:38

=IF(MAX(MMULT(1-ISERR(FIND(","&ROW($1:$36)&",",","&IF({1,0},A2,B$2)&",")),{1;1}))=2,"有",N(C1)+1)

风雨几许 发表于 2022-2-10 14:42:33

换个思路 C2
=IF(OR(LEN(A2&B$2)-LEN(SUBSTITUTE(","&A2&","&B$2&",",","&ROW($1:$99)&",",))>4),"有",N(C1)+1)

行成于思毁于随 发表于 2022-3-3 04:39:44

感谢大佬们的回复！
大佬们的公式都 可以解决问题，再次谢谢大佬们！
花已用完，下次一定补上
页: [1]
查看完整版本: 请教大佬，如何用公式查找两行的相同数，谢谢！