排序 每區取2名最高數值 (12657)

E2:F12{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(COUNTIFS($B$2:$B$16,$B$2:$B$16,$C$2:$C$16,">"&$C$2:$C$16)<2,FIND($B$2:$B$16,"DCBA")/1%%+$C$2:$C$16/1%+ROW($2:$16)),ROW(A1)),2)),"")