取前20%與後30%名值 (9833)

F12:G14{=SMALL(IF($A:$A=$E12,$B:$B),ROUND(COUNTIF($A:$A,$E12)*(0.2+(A$1=$B$1)*0.5),))

另解F12:G14{=INDEX($B:$B,RIGHT(SMALL(IF($A$2:$A$55=$E12,((COUNTIFS($A$2:$A$55,$A$2:$A$55,$B$2:$B$55,"<"&$B$2:$B$55)+1)/1%+ROW($2:$55))*IF(COLUMN(A1)=1,1,-1)),ROUND(COUNTIF($A:$A,$E12)*COLUMN(B1)*10%,)+(A$1=$B$1)),2))

区域数组 F17:G17下拉 {=SMALL(IF(A:A=E12,B:B),ROUND(COUNTIF(A:A,E12)*{0.2,0.7},))