Problem with MINIFS and MAXIFS

apologies I had a typo in my prior suggestion(s), perhaps the below will work for you?

Formula:

F2:

=REPT("X",IFERROR(AGGREGATE(14,6,($E$2:$E$11+ROW($E$2:$E$11)/1000)/($A$2:$A$11=$A2)/(COUNTIFS($A$2:$A$11,$A$2:$A$11,$D$2:$D$11,"<"&$D$2:$D$11)=0),1)=($E2+ROW($E2)/1000),0))

copied down