Min formula excluding 0

[stephen.smith]

Hi guys i am performing a min formula on a series of data but cells that have a 0 value are throwing my formula, any help??
e.g. =min(D3:D100) this is the formula i am using
however i dont want to include any cells with values that have a 0.
Thanks again

 

[VoG]

Try

=MIN(IF(D3:D300>0,D3:D300))

confirmed with CTRL + Shift + Enter, not just Enter.

 

[stephen.smith]

can this also be performed to find the second smallest number in a series of data excluding 0.
thanks

 

[VoG]

Try, CSE entered

=SMALL(IF(D3:D300>0,D3:D300),2)

 

[Kaps_mr2]

try :-

=SMALL(IF((d3:d100)>0,d3:d100),2)

confirmed with control , shift enter.thanks

Kaps

 

[rmed52]

I am also trying to do something similar but all the formulas seem to just give me the smallest number excluding zero, and not changing at all for the second smallest number, am I doing something wrong? this is what I wrote:
=SMALL(IF(('Hidden Entry'!B2:B800)>0,'Hidden Entry'!B2:B800),3)
I also tried:
=MIN(IF('Hidden Entry'!B2:B800>0,'Hidden Entry'!B2:B800))