排序 扣除最大 最小指定數 (12853)

F2=IF(ROW(A1)>COUNT(B:B)-D$2*2,"",SMALL(B:B,ROW(A1)+D$2))

G2{=IF(ROW(A1)>COUNT(B:B)-D$2*2,"",INDEX(B:B,SMALL(RIGHT(SMALL(IF(B$2:B$99>0,B$2:B$99/1%+ROW($2:$99)),ROW(INDIRECT(D$2+1&":"&COUNT(B:B)-D$2))),2)*1,ROW(A1))))



留言