To get the MAX Value

[anuvnair]

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 from these values and from that i have to get the maximum....How its possible from single line formula...How i did is using IF..and I first orinted the values to anoter cell and then usng MAX fn to find the maximum..if any easy way please help me....


Thank you

Anu

 

[Debraj]

Hi Anu,


Welcome to the forum..


use below Single Line Formula..

=MAX(IF((Range>29)*(Range<40),Range,""))


which is like.. 


=MAX(IF(($A$1:$A$6>29)*($A$1:$A$6<40),$A$1:$A$6,""))

Confirm the formula by Ctrl + Shift + Enter not just Enter.


Regards,

Deb

 

[anuvnair]

Hi Debraj sir,


Thank you very much... My wok finished...........


Regards

Anu

 

[Debraj]

Hi Anu,


Thanks for feedback.. don't hesitate for further help if required.


Regards!

Deb