lowest number in a set EXCLUDING zero

G

Guest

I'm trying to figure out which formula to use to find the lowest value (all
numbers) in a range excluding zero. I've tried MIN, MINA and DMIN, which I
think is the correct one....but I'm not sure how to set the criteria to >0

Thanks for any help
 
G

Guest

This is an array formula, entered by pressing Ctrl-Shift-Enter

=MIN(IF(A1:A3>0,A1:A3))
 
G

Guest

A non-array approach I saw Harlan Grove use:

=SMALL(A1:A7,COUNTIF(A1:A7,"<=0")+1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lowest number excluding zero 2
Looking for formula for lowest costs, excluding zero 7
Average of values in row excluding the highest and lowest value? 18
Trying to subtract the two lowest values from a row of numbers 4
How do I find the minimum value greater than zero 1
Return the minimum number in a range excluding zero 3
MIN excluding 0s 3
I need to return the lowest time value in a range of cells. 2

Top