Min Excluding Value
This seems to work.
Thanks!
"Ron Coderre" wrote:
Try this ARRAY FORMULA (committed with CTRL+SHIFT+ENTER):
=MIN(IF(ISNUMBER(A1:A10)*(A1:A10<-273),A1:A10))
Is that something you can work with?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"kazoo" wrote in message
...
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!
|