各職等 最高與最低薪水 (12586)

F2:G6{=INDEX(PERCENTILE(IF(LOOKUP(ROW($2:$17),ROW($2:$17)/($B$2:$B$17<>""),$B$2:$B$17)=$E2,$C$2:$C$17),{1,0}),COLUMN(A1))