Min Value using array ignores Zero

M

mauddib

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

B

Bob Phillips

=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)

B

Bob Phillips

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 said:
=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 said:
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