| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN to find specific lowest value
how about a nice array formula which must be entered/edited with
ctrl+shift+enter =MIN(IF(M2:M220,M2:M22)) -- Don Guillett SalesAid Software "Jane" wrote in message ... my data: 0 0 0 0 .01 .93 .03 I need to find the lowest value NOT including 0. help with formula please..... thank you! jane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i find a specific date of a database | Excel Discussion (Misc queries) | |||
| How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| Find lowest value in a range | Excel Worksheet Functions | |||
| How to find highest, lowest and last cell in a row? | Excel Worksheet Functions | |||
Hybrid Mode
