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.
Thanks in advance
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.
Thanks in advance
Sekar
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.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
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.
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
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)
Bookmarks