如题所述
å¨E2è¾å ¥ =INDEX(A:A,SMALL(IF(MATCH(A$2:A$8,A$2:A$8,0)=ROW($1:$7),ROW($2:$8),2^20),ROW(A1)))
æctrl+shift+å车
ç¶åä¸æå¡«å
F2è¾å ¥
=SUMIF(A$2:A$9,E2,B$2:B$9)