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

碧塬红咖绿色天然咖啡

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

2021-10-25 21:49 上传

点击文件名下载附件
请教老师，用公式，每行的2个数在另外三行都有，就显示出来，谢谢！.rar

谈笑之间

C2公式：（下拉，上拉）
=IF(COUNT(FIND(","&--MID(SUBSTITUTE(B2,","," "),{1,5},4)&",",","&F$1:F$3&","))=6,"有",IF(ROW()=1,1,N(C1)+1))

吾甚屌

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

青山寨主

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

一生二二生三三生万物

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

养兰怡情

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

法務大臣

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

2021-10-25 21:49 上传

点击文件名下载附件
我要1行到5行，公式都能计算，烦请老师帮调整下公式，谢谢！.rar

陈灿

可以改的嘛
=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

冷英

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