=MAX(SUMPRODUCT(($A$1:$A$8=A1)*($C$1:$C$8)),SUMPRODUCT(($A$1:$A$8=A1)*($D$1:$D$8)))

Copy down as needed