公式有点长F11单元格=
=INDEX($A:$A,SMALL(IF((LEFT($A$2:$A$35)={"A","B","C","D"})*RANK($B$2:$B$35,$B$2:$B$35)=--RIGHT(SMALL({1,2,3,4}*10^5+(LEFT($A$2:$A$35)={"A","B","C","D"})*RANK($B$2:$B$35,$B$2:$B$35),{34,68,102,136}),4),ROW($2:$35)),ROW(A1)))
数组公式CTRL+SHIFT+ENTER组合键结束公式
