Formula to find lowest number greater than zero

[sharky12345]

Guys,

Can anyone help me with this formula? I want it to show the lowest number greater than zero and ignorning blank cells but it is not working;

=MIN(IF(Database!$B$7:$B$5000=3,Database!$J$7:$J$5000))

 

[Aladin Akyurek]

Guys,

Can anyone help me with this formula? I want it to show the lowest number greater than zero and ignorning blank cells but it is not working;

Control+shift+enter, not just enter:

=MIN(IF(Database!$B$7:$B$5000=3,IF(Database!$J$7:$J$5000>0,Database!$J$7:$J$5000)))

 

[sharky12345]

Brilliant - thanks!

 

[hiker95]

sharky12345,

See:

Minimum Based on Multiple Criteria
http://www.xl-central.com/min-multiple-criteria.html

 

[sharky12345]

Thanks guys - very helpful, as usual!

 

[Aladin Akyurek]

Brilliant - thanks!

You are welcome.

 

[hiker95]

sharky12345,

You are very welcome. Glad we could help.

Come back anytime.