Maybe this
H7:
=LOOKUP(1,1/(MMULT(($D$6:$D$21>TRANSPOSE($D$6:$D$21))+($D$6:$D$21=TRANSPOSE($D$6:$D$21))*(($E$6:$E$21=TRANSPOSE($E$6:$E$21))*($C$6:$C$21>TRANSPOSE($C$6:$C$21))+($E$6:$E$21>TRANSPOSE($E$6:$E$21))),ROW($6:$21)^0)=ROWS($6:$21)-ROWS($6:6)),$B$6:$B$21)
I7:
=LOOKUP(1,1/(MMULT(($D$6:$D$21>TRANSPOSE($D$6:$D$21))+($D$6:$D$21=TRANSPOSE($D$6:$D$21))*(($E$6:$E$21=TRANSPOSE($E$6:$E$21))*($C$6:$C$21>TRANSPOSE($C$6:$C$21))+($E$6:$E$21>TRANSPOSE($E$6:$E$21))),ROW($6:$21)^0)=ROWS($6:$21)-ROWS($6:6)),$D$6:$D$21)
Confirm them all with Ctrl+Shift+Enter then drag down
Bookmarks