# 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.

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.

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.

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

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1