LOWEST Non-Zero Numbers

  • Thread starter Thread starter UCIrvine
  • Start date Start date
U

UCIrvine

I need the lowest non-zero number in a series of cells.

Microsoft Knowledge Base Article - 60116

This article offers the following formula:
=MIN(IF(Y3:Y34>1,Y3:Y34))


This kicks out #VALUE! error, even though within the
formula creatot, it provides the correct answer.

Any ideas on how to do this differently?
 
You need to enter it as an array formula with <Ctrl> <Shift> <Enter>.

Also, do you mean >1 or >0?
 
Yeah, less than 0, I got desperate and tried less than 1.

You're right, it needed to be an array.

IT WORKED!!! Thank you so much.
 
Back
Top