MIN function

[Ogniani]

Hello, I have a large database with two criteria (offers and product type). The aim is to find which offer contains the most proposals with a minimum price (e.g. row 8, column F,G,H). The manual solution is not possible due to the large number of rows (product type), so I hope for an automatic solution.

I have already tried the following functions, but I am obviously mistaken because they do not give the correct results:
=MINIFS(B3:D3,B2:D2,B2,A3:A6,A3)

array formulas:
{=MIN(IF(B2:D2=B2,IF(A3:A6=A3,B3:D3)))}
{=MIN(IF(B2:D2=B2,B3:D3))}

Is there any solution or not possible through excel?

 

[Fluff]

Glad we could help & thanks for the feedback.