求公式

huangrk

附件求函数公式

inrever

1. =IF(AND(C$15>=$C5,C$15<=$D5),$E5,"")&IF(AND(C$15>=$F5,C$15<=$G5),$H5,"")&IF(AND(C$15>=$I5,C$15<=$J5),$K5,"")

复制代码

hugeinfo

=LET(b,DROP(REDUCE("",$B$5:$B$10,LAMBDA(x,y,VSTACK(x,HSTACK(IF(SEQUENCE(3),y),  WRAPROWS(OFFSET(y,,1,,9),3))))),1),BYCOL(IF(ISNUMBER(VDB(1,,FILTER(CHOOSECOLS(b,3),CHOOSECOLS(b,1)=$B16),FILTER(CHOOSECOLS(b,2),CHOOSECOLS(b,1)=$B16),$C$15:$K$15)),FILTER(CHOOSECOLS(b,4),CHOOSECOLS(b,1)=$B16),""),LAMBDA(a,TEXTJOIN("",,a))))

jerrike

1. =IFERROR(LET(x,HSTACK(REPTARRAY($B$5:$B$10,3),VSTACK($C$5:$E$10,$F$5:$H$10,$I$5:$K$10)),FILTER(TAKE(x,,-1),(TAKE(x,,1)=$B16)*(CHOOSECOLS(x,2)<=C$15)*(CHOOSECOLS(x,3)>=C$15))),"")

复制代码

袁勇

1. =IFERROR(LOOKUP(1,0/(($C5:$I5<=C$15)*($D5:$J5>=C$15)*ISTEXT($E5:$K5)),$E5:$K5),"")

复制代码

右拉下拉。