=MAX(IF($B$2:$B$9=B2,$E$2:$E$9,""))同时按CTRL SHFT 回车键，再下拉
=INDEX(B:B,MATCH(MAX(E:E),E:E,))
=LOOKUP(1,0/(MAX(E2:E100)=E2:E100),B2:B100)
=offset($A$1,match(max(E:E),E:E,0)-1,1,1,1)
