请教老师，用公式，每行的2个数在另外三行都有，就显示出来，谢谢！

cartel

请教老师，用公式，每行的2个数在另外三行都有，就显示出来，谢谢！.rar (8.92 KB, 下载次数: 22)

2021-10-25 21:49 上传

点击文件名下载附件

魚。。

C2公式：（下拉，上拉）

1. =IF(COUNT(FIND(","&--MID(SUBSTITUTE(B2,",","   "),{1,5},4)&",",","&F$1:F$3&","))=6,"有",IF(ROW()=1,1,N(C1)+1))

复制代码

客都梅州

魚。。 发表于 2021-10-25 22:17
C2公式：（下拉，上拉）

欢迎大俊哥归来


三键盘下拉，支持4位数，抄袭一下
=IF(COUNT(FIND(","&--MID(SUBSTITUTE(B1,",","   "),{1,5},{4,9})&",",","&F$1:F$3&","))=6,"有",N(INDIRECT("r[-1]c",))+1)

cinlo

看了鱼老师的公式才看懂：
C1=IF(COUNT(FIND(","&MID(SUBSTITUTE(B1,",","   "),{1,4},4)*1&",",","&F$1:F$3&","))=6,"有",N(INDIRECT("r[-1]c",))+1)下拉

piny

C1=IF(COUNT(SEARCH("*,"&SUBSTITUTE(B1,",",",*,")&",",REPT(F$1:F$3&",",2)))=3,"有",N(INDIRECT("r[-1]c",))+1)

cartel

感谢老师们的帮忙！公式都能计算3行，
我没说清楚，我要1行到5行都能计算
还烦请老师们帮调整下，先谢了！
请见下面附件，

cartel

我要1行到5行，公式都能计算，烦请老师帮调整下公式，谢谢！.rar (38.83 KB, 下载次数: 5)

2021-10-26 17:33 上传

点击文件名下载附件

客都梅州

cartel 发表于 2021-10-26 17:33

可以改的嘛
=IF(COUNT(FIND(","&--MID(SUBSTITUTE(B1,",","   "),{1,5},{4,9})&",",","&F$1:F$2&","))=4,"有",N(INDIRECT("r[-1]c",))+1)第一个红2就改2,3就改3
第二个红1行就2,2行就4,3行就6

cartel

客都梅州 发表于 2021-10-26 18:20
可以改的嘛
=IF(COUNT(FIND(","&--MID(SUBSTITUTE(B1,",","   "),{1,5},{4,9})&",",","&F$1:F$2&","))=4 ...

感谢老师的帮忙！
问题已得到解决，再次感谢！