排序 各組以最後日期的金額 日期無排序 (13746)

E2{=RIGHT(MAX((C$2:C$16=C2)*B$2:B$16*10^8+D$2:D$16/1%+ROW($2:$16)),8)*1

G2:I6{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH($C$2:$C$16,$C:$C,)=ROW($2:$16),$E$2:$E$16),ROW(A1)),2)),"")

G10:I14{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH($C$2:$C$16,$C:$C,)=ROW($2:$16),RIGHT(SMALL(($C$2:$C$16=TRANSPOSE($C$2:$C$16))*TRANSPOSE($B$2:$B$16*10^5+$D$2:$D$16/1%+ROW($2:$16))+ROW($2:$16)*10^10,ROW($1:$15)*15),5)*1),ROW(A1)),2)),"")