| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimum value needs to be greater than zero
Hi all,
this is what i'm exactly looking for that in a selected range of cells, i'm looking for the minimum value and it needs to be greater than zero. whn i give =Min(A1:D25), it gives 0, and i am looking for 3 which is the smallest after 0... regards, Divy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Minimum value needs to be greater than zero
Use MATCH(lookup_value,lookup_array,match_type)
with match tye = -1 =match(3,A3:B6,-1) "Divy" wrote: Hi all, this is what i'm exactly looking for that in a selected range of cells, i'm looking for the minimum value and it needs to be greater than zero. whn i give =Min(A1:D25), it gives 0, and i am looking for 3 which is the smallest after 0... regards, Divy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Minimum Date Greater than Today() | Excel Worksheet Functions | |||
| Minimum value needs to be greater than zero | Excel Programming | |||
| Minimum value needs to be greater than zero | Excel Programming | |||
| Find minimum value greater than a particular value | Excel Worksheet Functions | |||
| minimum greater than zero | Excel Worksheet Functions | |||
Linear Mode
