Sir,
Yesterday you have given me the formula as
=MAX(if(($A$1:$A$6>29)*($A$1:$A$6<40),$A$1:$A$6,""))
Today because of typing this much - i have 100 excel sheets with 250 values in each to find the max value- i just selected the cell instead of typing $A$1:$A$6.So the formula now...
Hi chandoo,
How r you?? Hoope you going fine..I got your Project Mangement tools...Thanks..Now i have a problem for finding the max from a set of values...
I have a set of vales.
35.5
36.5
25.5
20.5
31.5
30.5 and so on
I have to find a value which should be in a range between 29 and 40...