Problem with MINIFS and MAXIFS

Hello, I have a file that groups similar data, the duplicated count is the number of data in each group, I have to assign the golden ID (X) in each group: There are two conditions, the data that has the smallest type is the golden ID, example if we have two data that have type2 and type4, the data that has the type2 is the golden, but there is another condition if we have two data that have the same type, the data that will be the golden is the one with the largest number. I tried to write a code VBA and formula that shows the golden ID but in group C for example, we see that it affects the golden ID to data which has the number 20 but I want that the golden will be the next data that has the number 40. here is what my file looks like

based on your sample data, if we assume it's stored in A1:E11 (with row being headers), one option:

F2:
=REPT("X",IFERROR(AGGREGATE(14,6,$E$2:$E$11/($A$2:$A$11=$A2)/(COUNTIFS($A$2:$A$11,$A2,$D$2:$D$11,"<"&$D2)=0),1)=$E2,0))
copied down

it's not particularly efficient though.

Thank you for your answer, your formula works fine but it affects the Golden X to all types 1, I want only one Golden X per group.
I also want to know please what it means 14 and 6 at the beginning of your formula.

I have joined the file, in the golden column this is the result I want to get. thank you

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

OK; I think the revised formula in my previous post [#5] should generate expected results?

Apologies for confusion caused by my earlier mistake.

Thank you for your time. But the golden X appears only for the first group even if I copied down ?!!

see attached, note I have switched to use structured references per your use of the Table object