Here's the formula!

Assuming data is in cells E11-E18, then:

**=MIN(IF(E11:E18>0,E11:E18,FALSE))**

Basically, this formula says that, get minimum value IF the number in the array is greater than zero. If it is zero or below, do not consider it.

IMPORTANT NOTE: then instead of using only the enter key, use

**CTL-SHIFT-ENTER.**This will convert the formula into an ARRAY FORMULA which will make this work. You can see if it is succesfully converted to array formula if you see a bracket enclosing the formula.

This formula can also be used with different conditions. This is one "MIN IF" formula.

Hope this helps! Note: You can also use this concept to create a "MAX IF" formula.

## 1 comments:

This helped a lot, but how do you perform this function on multiple tabs? For example:

=MIN(TabA!A1, TabB!A1, TabC!A1)

I still want to return the lowest number from each of these cells excluding zero.

Thanks

Post a Comment