Need to add to an existint formula so it doesnt counts zeros

**mrudd72** · 03-22-2013, 09:18 PM

I have an existing formula that finds the lowest number if it isn't a duplicate..

=IF(COUNTIF(H10:H89,MIN(H10:H89))=1,MIN(H10:H89),0)

The problem is, it is counting zeros. Can I modify this so it won't count the zeros?

**martindwilson** · 03-22-2013, 09:30 PM

if you want it to ignore 0 completely and return say 2 if thats the minimum not duplicated
=IF(COUNTIF(H1:H10,SMALL(H1:H10,1+COUNTIF(H1:H10,0)))=1,SMALL(H1:H10,1+COUNTIF(H1:H10,0)),0) adjust ranges to suit