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

=IF(SMALL(A1:D25,1)=0,SMALL(A1:D25,2),SMALL(A1:D25 ,1))

--
Gary's Student
gsnu200707


"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

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:A100,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" 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

On Feb 19, 9:17 pm, Ron Coderre
wrote:
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:A100,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" 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- Hide quoted text -

- Show quoted text -

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