Finding the minimum value with the exeption of zero

**phil@micro** · 01-23-2009, 06:04 AM

Hi everyone,
I have a problem involving displaying the minimum value of a range of cells, I have used the following to display the minimum:
=MIN(C3,F3,I3)
this works great but what I really need to do is display the minimum value above zero, so I need to find a way of comparing cell values, disregard any zeros and display the next lowest value.
thanks for taking the time to read my post,
Phil

**DonkeyOte** · 01-23-2009, 06:07 AM

As an array - confirmed with CTRL + SHIFT + ENTER

=MIN(IF((MOD(COLUMN(C3:I3),3)=0)*(C3:I3<>0),C3:I3))

Once array is set the above will appear encased within { }

**pankajkaushik12** · 01-23-2009, 06:24 AM

Originally Posted by phil@micro

Hi everyone,
I have a problem involving displaying the minimum value of a range of cells, I have used the following to display the minimum:
=MIN(C3,F3,I3)
this works great but what I really need to do is display the minimum value above zero, so I need to find a way of comparing cell values, disregard any zeros and display the next lowest value.
thanks for taking the time to read my post,
Phil

hi use this function
=small(a1:a5,2)

thanks
pankaj