title: googlefinance function in google sheets can't get min when N/A value
body: <p>I am looking to get the min price in a range of date using googlefinance function. However, some of the stocks have a missing #N/A value. Using a simple min function doesn't work.</p>
  
  <p>I tried wrapping a filter function, however, since I am getting the values from a googlefinance function, I am not sure what to put for arguments.</p>
  
  <pre><code>=MIN(filter(Index(GOOGLEFINANCE("BAC";"low";"2016-11-2";"2017-11-2";"DAILY");;2));SOMETHING&lt;&gt;0)
  </code></pre>
  
  <p>Edit: Found a pretty ugly solution. It's working, but I'm still open to a better solution.
  Here is solution: </p>
  
  <pre><code>=MIN(filter(Index(GOOGLEFINANCE("BAC";"low";"2016-11-2";"2017-11-2";"DAILY");;2));Index(GOOGLEFINANCE("BAC";"low";"2016-11-2";"2017-11-2";"DAILY");;2)&lt;&gt;0)
  </code></pre>