请教老师，用公式找出一行中包含另一行的全部相同数，谢谢！

cartel · 发表于 2024-2-21 14:10

明象 · 发表于 2024-2-21 14:41

=IF(SUM((TEXTSPLIT($E$62,",")=TEXTSPLIT(B6,,","))*1)=3,"有",ROW(A1)-COUNTIF($E$5:E5,"有"))

cartel · 发表于 2024-2-21 18:47

明象发表于 2024-2-21 14:41
=IF(SUM((TEXTSPLIT($E$62,",")=TEXTSPLIT(B6,,","))*1)=3,"有",ROW(A1)-COUNTIF($E$5:E5,"有"))

感谢老师回复！
”有“与”有“之间为连续数字，
比如，有与有之间有3个空格就为1，2，3，
接下来有与有之间有1个空格就为1，或10个空格就为1到10
另外今天花已送完，明天再送给老师，谢谢！

一杯绿茶来了 · 发表于 2024-2-21 19:20

本帖最后由一杯绿茶来了于 2024-2-21 19:23 编辑

=IF(AND(ISNUMBER(FIND(","&MID($E$62,{1,3,6},{1,2,2})&",",","&B6&","))),"有",MAX($D5:D5)+1)

quqiyuan · 发表于 2024-2-21 20:18

=IF(COUNT(0/FIND(","&TEXTSPLIT($E$62,,",")&",",","&B6&","))=3,"有",N(D5)+1)

mykitami · 发表于 2024-2-21 23:21

=SCAN(0,IF(MMULT(1*ISNUMBER(FIND(","&TEXTSPLIT(E62,",",,1)&",",","&B6:B24&",")),ROW(1:3)^0)=3,"有","@"),LAMBDA(x,y,IF(y="有",y,N(x)+1)))

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

[已解决] 请教老师，用公式找出一行中包含另一行的全部相同数，谢谢！