D3:D8{=INDEX(A:A,SMALL(IF($B$2:$B$30>500,ROW($A$2:$A$30),99),ROW(A1)))&""
E3:F8{=INDEX($A:$A,SMALL(IF(MMULT(N($B$2:$B$30-LEFT(D$2:E$2,FIND("以",D$2:E$2)-1)>0),{1;1})=1,ROW($2:$30),99),ROW(A1)))&""
G3:G8{=INDEX(A:A,SMALL(IF($B$2:$B$30<50,ROW($A$2:$A$30),99),ROW(A1)))&""
I2:I23{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(D$2:G$8<>"",COLUMN(D:G)*10001+ROW($2:$8)/1%),ROW(A1)),4),"!R0C00"),),"")
留言
張貼留言