You're welcome!
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"kazoo" wrote in message
...
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!