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),E110)
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

"PC Instructor" <PC wrote in message
...
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!