title: Google Spreadsheet =query - ignore entities where cell is empty
body: <p>my starting table looks similar to the following</p>
  
  <pre><code>Person 1, 75
  Person 2, 48 
  Person 3,
  Person 4, 82
  Person 5,
  Person 6, 93 
  ...
  </code></pre>
  
  <p>I now try to include in following query a "where" statement to exclude entities that have no numeric value. This is what I currently have to show me the lowest 5 values of the set above and it works so far</p>
  
  <pre><code>=QUERY('DPS Transpose Tables'!D1:E29;"select D, max(E) group by D order by max(E) asc limit 5 label max(E)  ''";0)
  </code></pre>
  
  <p>How can I add something like this that works</p>
  
  <pre><code>=QUERY('DPS Transpose Tables'!D1:E29;"select D  where (E&lt;&gt;"" OR Is not NULL), max(E) group by D order by max(E) asc limit 5 label max(E)  ''";0)
  </code></pre>
  
  <p>Thanks a million in advance!</p>