How calculate a MIN excluding the 0 values

[jimmy]

Hello,

I would need some help.
Can someone tell me which formula i have to use in order to calculate the
MIN value on column B excluding the 0 values?


A B
day 1 1.25
day 2 1.22
day 3 1.1
day 4 1.11
day 5 1.09
day 6 1.06
day 7 0
day 8 1.01
day 9 1.02
day 10 0.99
day 11 0.95
day 12 0.9
day 13 0
day 14 0.85
day 15 0
day 16 0.87
day 17 0
day 18 1.1
day 19 1.2
day 20 0.75
day 21 0.9
day 22 0
day 23 0.75
day 24 0.76
day 25 0
day 26 0.5

Thanks for your help

 

[Mike H]

Hi,

Try this

=MIN(IF(B1:B40<>0,B1:B40,FALSE))

Which is an array so commit with CTRL+Shift+Enter nt just enter. If you do
it correctly Excel will put curly barckets around the formula {}. You can't
type these yourself.

Mike

 

[Don Guillett]

This is an array formula that must be entered using ctrl+shift+enter

=MIN(IF((E1:E23>0),E1:E23))

 

[Gary''s Student]

=AVERAGE(IF(B1:B26<>0,B1:B26))
as an array formula entered with
CNTRL-SHFT-ENTER
rather than just the
ENTER
key

 

[jimmy]

Tanks Mike H.
It works now.


"Mike H" escreveu:

Hi,

Try this

=MIN(IF(B1:B40<>0,B1:B40,FALSE))

Which is an array so commit with CTRL+Shift+Enter nt just enter. If you do
it correctly Excel will put curly barckets around the formula {}. You can't
type these yourself.

Mike

 

[muddan madhu]

Try this one

=SMALL(B1:B30,COUNTIF(B1:B30,0)+1)