Just out of curiousity, in finding the MINIMUM of positive values in a
range
(say, A1:A10), can anyone explain why the ARRAY FORMULA

=MIN(($A1:$100,$A1:$10) returns zero, regardless; but
=MAX(($A1:$100,$A1:$10) gives correct results.

The logic of Array construct in Formula suggests to me the formula
should work just as well for MIN as it does MAX and SUM (with AVERAGE
and STDEV being exceptions for obvious reasons).

PS: I have no problem with the IF qualification which never fails viz.
=MIN(IF($A1:$100,$A1:$10))


TIA
..


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=375644