title: How to exclude 0 and blank cells when using excel MIN function
body: <p>Got this formula:</p>
  
  <pre><code>{=IF(A4=MIN((C4=$C$4:$C$46711)*(B4=$B$4:$B$46711)*($A$4:$A$46711)),"First Event","All")}
  </code></pre>
  
  <p>I'm using the same one for MAX, and it works just fine. But when changing to MIN it fails, and I suppose it's because of value 0 and/or blank cells in my range. I've tried to add "ISNUMBER" after the "IF" but it doesn't do the trick...</p>
  
  <p>How can this formua be modified to return lowest value, not counting 0 and/or blank cells in Column A?</p>