Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A B C D E
0125 0.0% 0.0% 3.3% 0.0% 0108 0.0% 0.0% 1.2% 0.0% 0110 0.0% 0.0% 3.9% 0.0% 0104 6.3% 0.0% 0.0% 0.0% 0 -100.0% -100.0% -100.0% -100.0% 0 -100.0% -100.0% -100.0% -100.0% 0 -100.0% -100.0% -100.0% -100.0% I have two issues that I cannot resolve. I need to return the minimum result from the above column d excluding zero and the negative numbers. I have tried =min(if(d1:d70,d1:d7) with no luck. I also need to return the corresponding information in column A from the selected minimum value in column D. Thanks in advance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help! Minimum Excluding zeros across multiple sheets | Excel Worksheet Functions | |||
Minimum formula the excludes zeros | Excel Worksheet Functions | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
hide zeros & negatives for date formulas | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |