Using MIN function

[PC Instructor]

Hello,

How can I use the minimum function to return the lowest number in a range,
while ignoring any zeros and any #N/A entries in the range?

Any help would be appreciated!

 

[Jacob Skaria]

Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=MIN(IF(ISNUMBER(D1100),IF(D1100>0,D1100)))

If this post helps click Yes

 

[PC Instructor]

Perfect! Thank you VERY much!

Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=MIN(IF(ISNUMBER(D1100),IF(D1100>0,D1100)))

If this post helps click Yes

 

[Ashish Mathur]

Hi,

You may also try this

1. Assume your data is in range E11:E18
2. In cell E10, enter heading
3. In E25, enter =AND(ISNUMBER(E11),E11>0)
5. In F24, enter heading
6. In cell F25, enter =DMIN(E10:E18,F24,E24:E25)

Hope this helps

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com