Find Smallest entry but excluding zero

J

jambun

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
 
S

Sandy Mann

I like that one, clever!

--


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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
M

Mike H

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

Mike
 
Top