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

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

"jimmy" wrote:

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

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

=MIN(IF((E1:E230),E1:E23))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jimmy" wrote in message
...
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

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


"jimmy" wrote:

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

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

"jimmy" wrote:

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

Try this one

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



On Sep 10, 9:55*am, jimmy wrote:
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