Lowest number greater than zero

  • Thread starter Thread starter GF
  • Start date Start date
G

GF

I am trying to determine the lowest number greater than
zero in an array of numbers containing numbers and text.
In order to determine the low score an a hole in a golf
tournement.
 
Assuming no negative values in the scores:

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

HTH
Jason
Atlanta, GA
 
Hi GF!

One way:

One way:

=MIN(IF(B2:B100>0,B2:B100))

This is an array formula entered by pressing and holding down Ctrl +
Shift and then pressing Enter.
 
Assuming no negative values in the scores:

=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
Click to expand...
...

Why make the assumption?

=MIN(IF(Range>0,Range)) [array formula]

or

=SMALL(Range,COUNTIF(Range,"<=0")+1)
 
Works great, thanks much.
GFerrin, Wichita, KS
-----Original Message-----
Assuming no negative values in the scores:

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

HTH
Jason
Atlanta, GA

.
Click to expand...
 
Back
Top