| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In part of a col of data, I need the minimum number, but exclude z
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| minimum function but want to exclude zero | Excel Discussion (Misc queries) | |||
| How to get the minimum number of one column while ignoring the err | Excel Discussion (Misc queries) | |||
| Conditional format of minimum number | Excel Worksheet Functions | |||
| excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
| How do I sum a number of columns and ignore the minimum value? | Excel Discussion (Misc queries) | |||
Threaded Mode
