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?
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?