评定等級 依年齡 (10764)


K4:N4=TEXT(OFFSET($B8,-SUMPRODUCT(N((LOOKUP($M1,LEFTB(SUBSTITUTE($D3:$F3,"-"," -"),2)*1,{1,2,3})={1,2,3})*MIDB($D4:$F7,FIND("秒",$D4:$F7)-2,2)>=K5)),),";;!N;@")


固定岁=TEXT(LOOKUP(,0/FREQUENCY(K5,--LEFT(RIGHT(SUBSTITUTE(OFFSET($C4:$C7,,MATCH($M1,{0,7,12})),"以内",),3),2)),$B4:$B8),";;!N;@")


留言