Min Value using array ignores Zero
 

Im trying to search a two column list using the following formula. Its
an array formula which I know not very much about....

{=MIN(IF((Sheet2!$F$3:$F$3500=E3)*(Sheet2!$J$3:$J$ 3500),(Sheet2!$J$3:$J$3500)))}

Its working almost perfectly. The only problem Im having is if the
values are, for example:

10
2
5
100
12
0

It will pick the 2 not the Zero.

I need to be able to pick the Zero in cases such as this. Does anyone
have hints on a tweak to the formula?

Gavin


--
mauddib
------------------------------------------------------------------------
mauddib's Profile: http://www.excelforum.com/member.php...fo&userid=4169
View this thread: http://www.excelforum.com/showthread...hreadid=346025

=MIN(IF((Sheet2!$F$3:$F$10=E3)*(Sheet2!$J$3:$J$10 =0),(Sheet2!$J$3:$J$10)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mauddib" wrote in message
...

Im trying to search a two column list using the following formula. Its
an array formula which I know not very much about....


{=MIN(IF((Sheet2!$F$3:$F$3500=E3)*(Sheet2!$J$3:$J$ 3500),(Sheet2!$J$3:$J$3500
)))}

Its working almost perfectly. The only problem Im having is if the
values are, for example:

10
2
5
100
12
0

It will pick the 2 not the Zero.

I need to be able to pick the Zero in cases such as this. Does anyone
have hints on a tweak to the formula?

Gavin


--
mauddib
------------------------------------------------------------------------
mauddib's Profile:
http://www.excelforum.com/member.php...fo&userid=4169
View this thread: http://www.excelforum.com/showthread...hreadid=346025

or even

=MIN(IF((Sheet2!$F$3:$F$10=E3),(Sheet2!$J$3:$J$10) ))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...

=MIN(IF((Sheet2!$F$3:$F$10=E3)*(Sheet2!$J$3:$J$10 =0),(Sheet2!$J$3:$J$10)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mauddib" wrote in message
...

Im trying to search a two column list using the following formula. Its
an array formula which I know not very much about....



{=MIN(IF((Sheet2!$F$3:$F$3500=E3)*(Sheet2!$J$3:$J$ 3500),(Sheet2!$J$3:$J$3500
)))}

Its working almost perfectly. The only problem Im having is if the
values are, for example:

10
2
5
100
12
0

It will pick the 2 not the Zero.

I need to be able to pick the Zero in cases such as this. Does anyone
have hints on a tweak to the formula?

Gavin


--
mauddib
------------------------------------------------------------------------
mauddib's Profile:
http://www.excelforum.com/member.php...fo&userid=4169
View this thread:
http://www.excelforum.com/showthread...hreadid=346025