Finding MIN value

  • Thread starter Thread starter Liz Hansen
  • Start date Start date
L

Liz Hansen

Hi,

I need to find the MIN value in an array and I'm using MIN(A1:A12).

My problem is that there are cells within this range that has the value of 0
(zero) and in my case they need to be ignored. How do I modify the function
in order to just look at any number larger than 0 and then find the smallest
of those?

Thanks!

Liz
 
Hi
try the array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:A12<>0,A1:A12))
 
Back
Top