區間 第一非空白 提取 (15419)

C2{=IF(ROW(A1)=1,INDEX(B:B,MATCH(1=1,B:B>0,)),INDEX(B:B,SMALL(IF((B$1:B$15=0)*(B$2:B$16>0),ROW($2:$16),99),ROW(A1)-(B$1>0))))&""

D2{=INDEX(B:B,SMALL(IF((T(INDIRECT("R["&ROW($1:$16)-ROW(A3)&"]C[-2]",))="")*(B$1:B$16>0),ROW($1:$16),99),ROW(A1)))&""

H2{=INDEX(G:G,SMALL(IF((G$1:G$15=0)*(G$2:G$16>0),ROW($2:$16),99),ROW(A1)))&""



留言