# Max and Minimum value for the given 2 columns

1. ## Max and Minimum value for the given 2 columns

Hello Friends

Please help me to extract the maximum and minimum values from Columns B:D based on the input from cells G3:H4 and need to plot the reslt by formula in light yellow cells I3:J4.  Register To Reply

2. ## Re: Max and Minimum value for the given 2 columns

could you explain how the max of AAA and BBB is 5 and the min is 25? It appears to me that the min of AAA and BBB is 5 and the max is 25.   Register To Reply

3. ## Re: Max and Minimum value for the given 2 columns

I don't understand your min and max answers in your sheet and you haven't answered, however, I will give you these two array formulas that work (provided your max for AAA / BBB is really 25 and your min for the same is really 5 (ditto for CCC / DDD which appear to be reversed).
for max =MAX(IF((\$B\$3:\$B\$14=\$G3)*(\$C\$3:\$C\$14=\$H3),\$D\$3:\$D\$14)) dragged down and for the min... =MIN(IF((\$B\$3:\$B\$14=\$G3)*(\$C\$3:\$C\$14=\$H3),\$D\$3:\$D\$14)) dragged down, AGAIN, both are array formulas so they will only work when you click inside the formula and hit ctrl/shift/enter at the same time so the { } appear around both ends - you cannot enter them by hand.  Register To Reply

4. ## Re: Max and Minimum value for the given 2 columns

In I3 copied right to J3 and all down :

=AGGREGATE(14+(I\$2="Min"),6,\$D\$3:\$D\$24/(\$B\$3:\$B\$24=\$G3)/(\$C\$3:\$C\$24=\$H3),1)

Regards
Bosco  Register To Reply

5. ## Re: Max and Minimum value for the given 2 columns

Thanks for all your formulas working well, i will use Bosco formula.

Thanks again  Register To Reply