| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a Minimum Number other than Zero within a Range
Hello All, I am trying to find the minimum number in a column range.
This range contains formulas that return a positive value or a 0. I am trying to find the minimum number other than 0. I tried to rewrite the formula so it would return "" other than 0. This works, however it causes the VALUE error on other cells that are linked to this range since there are no values. Is there a way to find the minimum above zero? Any help would be greatly apprieciated! Thank you. Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding maximum, minimum in a range consists both Positive and Negative numbers | Excel Worksheet Functions | |||
| Finding Minimum but if same number repeats in the range, then find | Excel Discussion (Misc queries) | |||
| Get a row number of range where a value is between minimum and max | Excel Worksheet Functions | |||
| Finding cell address for minimum number | Excel Programming | |||
| Finding the minimum in a selected number of rows of the same colum | Excel Worksheet Functions | |||
Threaded Mode
