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

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