View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kazoo kazoo is offline
external usenet poster
 
Posts: 16
Default Min Excluding Value

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!