非空循環連續顯示 (14617)

D2 下拉{=IF(ROW(A1)>(COUNTA(B:B)-1)*F$2,"",INDEX(B:B,SMALL(IF(B$2:B$16>0,ROW($2:$16)),MOD(ROW(A1)-1,COUNTA(B:B)-1)+1)))



留言