Problem with MINIFS and MAXIFS

[mimich]

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