| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding minimum value
I have to find minimum value in a range of column for eg. a1 to a100 other
than zero. The formula "=min(a1:a100)" returns value 0 if the minimum value is 0 but I require the minimum value other than zero (all my values are in positive side only) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
finding minimum value
Try
=MIN(if(A1:A1000,A1:A100)) Commt with CTRL SHIFT ENTER "ezil" wrote: I have to find minimum value in a range of column for eg. a1 to a100 other than zero. The formula "=min(a1:a100)" returns value 0 if the minimum value is 0 but I require the minimum value other than zero (all my values are in positive side only) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
finding minimum value
One way (array-entered: CTRL-SHIFT_ENTER or CMD-RETURN):
=MIN(IF(A1:A1000,A1:A100)) In article , ezil wrote: I have to find minimum value in a range of column for eg. a1 to a100 other than zero. The formula "=min(a1:a100)" returns value 0 if the minimum value is 0 but I require the minimum value other than zero (all my values are in positive side only) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a Minimum Number other than Zero within a Range | Excel Programming | |||
| finding minimum value excluding zero | Excel Discussion (Misc queries) | |||
| Finding a maximum/minimum date in 2006 | Excel Discussion (Misc queries) | |||
| Finding a minimum value and selecting the cell containing this val | Excel Worksheet Functions | |||
| PROBLEM FINDING MINIMUM | Excel Programming | |||
Hybrid Mode
