| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the minimum number in a range excluding zero
Hi
I am currently using the following to find the maximum value in a range($G$120:$G$219), when the corresponding value in range ($H$120:$H$219) is equal to a specific value. =SUMPRODUCT(MAX(($H$120:$H$219=DF120)*($G$120:$G$2 19))) My problem is that when i try to find the minimum by substuting the MAX() for MIN() i always get a Zero. Can anyone suggest how to return the lowest value that is not zero |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding minimum value excluding zero | Excel Discussion (Misc queries) | |||
| Finding Minimum Value in series, excluding zero values | Excel Worksheet Functions | |||
| average of several cells excluding the minimum | Excel Discussion (Misc queries) | |||
| Return minimum POSITVE value from range | Excel Discussion (Misc queries) | |||
| How do I get "minimum value" in a range to NOT return zero? | Excel Worksheet Functions | |||
Threaded Mode
