Find Smallest entry but excluding zero
 

I need to find the smallest number in a column which may have the
range from 0 to 9 but need to exclude 0 ie: strokes in a game of golf
so that I can calculate the lowest number of strokes taken. Zere means
that they have wiped the hole and therefore cannot be used.
Thanks EPJ

Find Smallest entry but excluding zero
 

Try

SMALL(A1:A100,1+COUNTIF(A1:A100,0))

Mike

" wrote:

I need to find the smallest number in a column which may have the
range from 0 to 9 but need to exclude 0 ie: strokes in a game of golf
so that I can calculate the lowest number of strokes taken. Zere means
that they have wiped the hole and therefore cannot be used.
Thanks EPJ

Find Smallest entry but excluding zero
 

I like that one, clever!

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Mike H" wrote in message
...
Try

SMALL(A1:A100,1+COUNTIF(A1:A100,0))

Mike

" wrote:

I need to find the smallest number in a column which may have the
range from 0 to 9 but need to exclude 0 ie: strokes in a game of golf
so that I can calculate the lowest number of strokes taken. Zere means
that they have wiped the hole and therefore cannot be used.
Thanks EPJ

Find Smallest entry but excluding zero
 

I only risked it with a golf question because it falls over with negative
values. But who ever got a hole in -1 :)

Mike

"Sandy Mann" wrote:

I like that one, clever!

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Mike H" wrote in message
...
Try

SMALL(A1:A100,1+COUNTIF(A1:A100,0))

Mike

" wrote:

I need to find the smallest number in a column which may have the
range from 0 to 9 but need to exclude 0 ie: strokes in a game of golf
so that I can calculate the lowest number of strokes taken. Zere means
that they have wiped the hole and therefore cannot be used.
Thanks EPJ

Find Smallest entry but excluding zero
 

Works brilliantly, thanks EPJ
On Sun, 11 May 2008 12:05:23 +0100, "Sandy Mann"
wrote:

I like that one, clever!