lowest number in a set EXCLUDING zero

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
This is an array formula, entered by pressing Ctrl-Shift-Enter

=MIN(IF(A1:A3>0,A1:A3))
 
Back
Top