Lowest number greater than zero

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.
 
J

Jason Morin

Assuming no negative values in the scores:

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

HTH
Jason
Atlanta, GA
 
N

Norman Harker

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.
 
H

Harlan Grove

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)
 
G

GF

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to add 4 lowest numbers from a column of 6 4
Getting smallest number > 0 in an array constant 3
count the number of rows with entries greater than zero 1
Adding cells until they are greater than a lookup cell and returning a value 1
How to highlight the lowest valued cell in a column in Excel 2003 2
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Subtraction from the lowest number postion wise in Column 3
Finding Average of last 5 entries 11

Top