Code to Determine The Largest Number From Different Groups of Numbers

[Bob Phillips]

Try this array formula

=IF(SUM(($A$1:$A$20=A1)*($B$1:$B$20=B1))=1,"Y",
IF(MAX(IF(($A$1:$A$20=A1)*($B$1:$B$20=B1),$C$1:$C$20))-LARGE(IF(($A$1:$A$20=A1)*($B$1:$B$20=B1),$C$1:$C$20),2)>=10,
IF(MAX(IF(($A$1:$A$20=A1)*($B$1:$B$20=B1),$C$1:$C$20))=$C1,"Y",""),
IF(MAX(IF(($A$1:$A$20=A1)*($B$1:$B$20=B1),$D$1:$D$20))=$D1,"Y","")))