Minimum value needs to be greater than zero

[Divy]

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(A125), it gives 0, and i am looking for 3
which is the smallest after 0...

regards,
Divy

 

[Gary''s Student]

=IF(SMALL(A125,1)=0,SMALL(A125,2),SMALL(A125,1))

 

[Ron Coderre]

With
A1:A10 containing numbers or blanks or text

This ARRAY FORMULA is the typical approach.
It returns the smallest NON-zero numeric value:
B1: =MIN(IF(A1:A10>0,A1:A10))

Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Divy]

With
A1:A10 containing numbers or blanks or text

This ARRAY FORMULA is the typical approach.
It returns the smallest NON-zero numeric value:
B1: =MIN(IF(A1:A10>0,A1:A10))

Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

Does that help?
***********
Regards,
Ron

XL2002, WinXP

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(A125), it gives 0, and i am looking for 3
which is the smallest after 0...

regards,
Divy- Hide quoted text -

- Show quoted text -

thnks buddy....
this works....
and wonderfully...