分數最後比例 提取 (13870)

F2:G7{=INDEX(A:A,SMALL(IF($B$2:$B$20<=SMALL($B:$B,ROUNDUP(COUNT($B:$B)*$D$2,)),ROW($2:$20),99),ROW(A1)))&""

I2:J7{=IF(ROW(A1)>ROUNDUP(COUNT($B:$B)*$D$2,),"",INDEX(A:A,RIGHT(SMALL(IF($B$2:$B$20>0,$B$2:$B$20/1%+ROW($2:$20)),ROW(A1)),2)))



留言