In part of a row of data, I need the minimum number, but I must exclude zeros.
The zeros have to remain in place for other reasons. (the use is for golf
scores, and I am seeking the best score ever for individuals who all have
their own column of data, but have zeros when they did not play) So I
have=MIN('THIS WEEK'!C140:C211), but that formula returns zero when one or
more of those cells are a zero