| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the MIN value, but greater than zero
I need to find the minimum value in a data range (F174:F188), but greater
than zero. I tried "=MIN(F174:F1880)" and it does not work. How can I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the MIN value, but greater than zero
Try
=MIN(IF(F174:F188 0,F174:F188)) Enter with Ctrl+Shift+Enter NOT just enter Mike "Glenn L." wrote: I need to find the minimum value in a data range (F174:F188), but greater than zero. I tried "=MIN(F174:F1880)" and it does not work. How can I do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the MIN value, but greater than zero
Worked like a charm! Thanks for taking the time to help, Mike!!
"Mike H" wrote: Try =MIN(IF(F174:F188 0,F174:F188)) Enter with Ctrl+Shift+Enter NOT just enter Mike "Glenn L." wrote: I need to find the minimum value in a data range (F174:F188), but greater than zero. I tried "=MIN(F174:F1880)" and it does not work. How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding cell value from top of a list greater than 0 | Excel Discussion (Misc queries) | |||
| Finding last value greater than 0 | Excel Worksheet Functions | |||
| lookup finding the next value that is GREATER | Excel Worksheet Functions | |||
| vlookup - finding the next value that is GREATER than the lookup value? | Excel Worksheet Functions | |||
| IF greater than...IF less than....====== | Excel Discussion (Misc queries) | |||
![Glenn L.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
