數據 公式內E2=INDEX({0,1,2,0,0,0,5,0,6,0,0,5,-6,3,0,1,0,2,0},N(IF({1},SMALL(IF({0,1,2,0,0,0,5,0,6,0,0,5,-6,3,0,1,0,2,0},COLUMN(A:S)),ROW(INDIRECT("1:"&COUNT(0/({0,1,2,0,0,0,5,0,6,0,0,5,-6,3,0,1,0,2,0}<>0))))))))
數據 B列=INDEX(B:B,N(IF({1},SMALL(IF(B2:B20,ROW(2:20)),ROW(INDIRECT("1:"&COUNT(0/(B2:B20<>0))))))))
留言
張貼留言