求助各位朋友 大神帮忙 看看 具体表格有说明 十万火急 求帮忙 在线等！！

waternew

h3: =LARGE(--TEXTSPLIT($L3,{"*","="}),COLUMN(A:A))
g3: =INDEX($A$3:$A$10,SUM(IF(($B$3:$B$10=H3)*($C$3:$C$10=I3)*($D$3:$D$10=J3),ROW($1:$8))))

博爱风雨同舟

=FILTER(A$3:A$10,BYROW($B$3:$E$10,LAMBDA(X,SUM(SIGN(MMULT(--(X=--TEXTSPLIT(L3,,{"*","="})),ROW($1:$4)^0)))))=4)

13923323256

hugeinfo 发表于 2024-11-28 11:38
=HSTACK(FILTER($A$3:$D$10,BYROW(DROP(REDUCE("",--DROP(TEXTSPLIT(L3,,{"*","="}),-1),LAMBDA(x,y,HSTACK ...

谢谢大神，排序可以也按标准数据1:1那样吗？

你是那块小饼干

=FILTER($A$3:$E$10,BYROW(SORT(REGEXP(L3,"\d+")*1,,-1,TRUE)=$B$3:$E$10,AND),"")

hugeinfo

13923323256 发表于 2024-11-28 13:59
谢谢大神，排序可以也按标准数据1:1那样吗？

可以
                  

13923323256

hugeinfo 发表于 2024-11-28 15:18
可以

能帮我写个不

hugeinfo

13923323256 发表于 2024-11-28 15:21
能帮我写个不

=LET(f,DROP(REDUCE("",L3:L10,LAMBDA(c,d,VSTACK(c,HSTACK(FILTER($A$3:$D$10,BYROW(DROP(REDUCE("",--DROP(TEXTSPLIT(d,,{"*","="}),-1),LAMBDA(x,y,HSTACK(x,BYROW(N($B$3:$D$10=y),LAMBDA(a,SUM(a)))))),,1),LAMBDA(b,SUM(b)))=3),TEXTAFTER(d,"="))))),1),SORTBY(f,MATCH(TAKE(f,,1),A3:A10,),1))

13923323256

hugeinfo 发表于 2024-11-28 15:29
=HSTACK(FILTER($A$3:$D$10,BYROW(N($B$3:$D$10=TRANSPOSE(SORT(--DROP(TEXTSPLIT(L3,,{"*","="}),-1),1, ...

就是这个能不能1:1对应显示呢

hugeinfo

13923323256 发表于 2024-11-28 15:32
就是这个能不能1:1对应显示呢

理解错了

试试这个
=LET(f,DROP(REDUCE("",L3:L10,LAMBDA(c,d,VSTACK(c,HSTACK(FILTER($A$3:$D$10,BYROW(DROP(REDUCE("",--DROP(TEXTSPLIT(d,,{"*","="}),-1),LAMBDA(x,y,HSTACK(x,BYROW(N($B$3:$D$10=y),LAMBDA(a,SUM(a)))))),,1),LAMBDA(b,SUM(b)))=3),TEXTAFTER(d,"="))))),1),SORTBY(f,MATCH(TAKE(f,,1),A3:A10,),1))

zt614472336

=DROP(REDUCE("",L3:L10,LAMBDA(a,b,VSTACK(a,FILTER(A3:E10,IF(BYROW(DROP(REDUCE("",TEXTSPLIT(TEXTBEFORE(b,"="),"*"),LAMBDA(x,y,HSTACK(x,ISNUMBER(FIND(y,B3:D10))*1))),,1),SUM)=3,1,0))))),1)