Find Smallest entry but excluding zero

  • Thread starter Thread starter jambun
  • Start date Start date
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
 
I like that one, clever!

--


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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
I only risked it with a golf question because it falls over with negative
values. But who ever got a hole in -1 :)

Mike
 
Back
Top