Finding the Minimum number greater then zero in a table

[qawhaq]

Is there a quick formula that will allow the minimum number greater the zero ina tabel to be found? MIN() returns zero if there are any in the table. I cannont change the table as doing so will alter other calculations on other tabs of the sheet any ideas?

 

[Juan Pablo González]

=MIN(IF(A1:A10>0,A1:A10))

array entered (That is, with control shift enter, not just enter)

 

[qawhaq]

Thanks that did the trick

 

[Mark W.]

Or, simply...

{=MIN(IF(A1:A10,A1:A10))}

 

[Scott R]

Or, simply...

{=MIN(IF(A1:A10,A1:A10))}

This will return negative values.
qawhaq wants positive values only.

 

[rrdonutz]

Here is another NON-ARRAY formula that will work:

=SMALL(A1:A10,COUNTIF(A1:A10,"<=0")+1)

Note, however, that this formula will return the #NUM! error if all values in A1:A10 are less than or equal to 0. The array formula listed above will return 0 as the answer . . .

--Tom

 

[Mark W.]

Or, simply...

{=MIN(IF(A1:A10,A1:A10))}

This will return negative values.
qawhaq wants positive values only.

Hmmm... you may have a point; however, qawhaq's concern was that he was returning zero which suggested to me that there weren't any negative values in his domain. If there are negative values, then my formula (as you correctly pointed out) won't do the job!

 

[Legacy 327601]

I am trying to run this formula: {=MIN(IF(B:B>0,B:B))} off of a column that is formula driven. The formula returns 0. Is there another MIN(IF( formula that will work for a column that is formula driven?