| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
minimum greater than zero
I have a table populated with equations. I need to write a function to find
the smallest value in that table. However, I want to ignore the zero values. From a dataset containing 8, 5, 0, 7 I want to find 5, not zero. How do you do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Minimum value in a range > 0 | Excel Discussion (Misc queries) | |||
| lookup - return minimum value | Excel Worksheet Functions | |||
| Sum minimum values in a pivot table | Excel Worksheet Functions | |||
| If Greater than when a formula Results in N/A | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
