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

(e-mail address removed)
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
 

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

The formula to find the smallest number in a row not equal to zero 6
Finding MIN value 3
find smallest number not equal to 0 2
find date in Col A corresponding to min value in Col B 15
COUNT IF NOT EQUAL TO ZERO 12
Adding excluding zero 2
evaluating columns of data 3
Find MIN but not zero..... 3

Top