Min Excluding Value
It works great with the numbers I provided above. But, how does this work if
have blank cells interspersed? It seems to still work if one of the values
is negative and there are blank cells, but if they are all positive, it
doesn't work.
For example:
Col A
Row1 4.3
Row2 5.7
Row3
Row4 -273
Row5 3.9
Row6 -273
"Gary''s Student" wrote:
Use the array formula:
=MIN(IF(B1:B6<-273,B1:B6))
enter it with CNTRL-SHFT-ENTER instead of ENTER
--
Gary''s Student - gsnu200771
"kazoo" wrote:
Is it possible to have a formula with a standard Excel function that gives the
Min value in a column excluding the number -273?
Example:
Col A
Row1 4.3
Row2 5.7
Row3 4.2
Row4 -273
Row5 3.9
Row6 -273
The formula should return a min of 3.9 for A1:A6
Thanks!
|