title: How do I make a google query that selects for row?
body: <p><strong>Example:</strong> </p>
  
  <p>If my data set is</p>
  
  <pre><code>A B C
  1 2 3
  5 6 7
  4 5 6
  </code></pre>
  
  <p>I could have "1", "5" and "4" show up by typing =query(A:C, <code>select A</code>).</p>
  
  <p>I could have "1" and "4" show up by typing =query(A:C, <code>select A where B &lt; 6</code>).</p>
  
  <p>Lets say I wanted to query only entries that appeared after a certain row. In this case, <code>row 3</code> is <strong>4, 5, 6</strong>. So if I want only results that are row 3 or below, I could add a fourth column <code>D</code> somewhere, fill <code>column D</code> with <code>=row()</code>, and then have only **** show up by typing</p>
  
  <p>=query(A:C, <code>select A where D &gt;= 3</code>).</p>
  
  <p>But I don't want to have to add a fourth column somewhere and fill it with the <code>=row()</code> formula. The query should be able to do this on its own.</p>