碧塬红咖绿色天然咖啡 发表于 2021-10-25 21:49:00

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

谈笑之间 发表于 2021-11-8 13:08:36

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

吾甚屌 发表于 2021-11-10 19:39:39

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

青山寨主 发表于 2021-11-16 08:01:01

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

一生二二生三三生万物 发表于 2021-11-24 03:06:43

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

养兰怡情 发表于 2021-11-29 13:33:43

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

法務大臣 发表于 2022-1-2 08:37:02

陈灿 发表于 2022-1-14 19:17:00

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

冷英 发表于 2022-1-28 23:56:02

感谢大佬的帮忙！
问题已得到解决，再次感谢！
页: [1]
查看完整版本: 请教大佬，用公式，每行的2个数在另外三行都有，就显示出来，谢谢！ ...