title: Find the first empty cell in the same column/row
body: <p>I am trying to work out a formula that will give me the row number of the first empty cell in a column. Currently I am using:</p>
  
  <pre><code>=MATCH(TRUE, INDEX(ISBLANK(A:A), 0, 0), 0)
  </code></pre>
  
  <p>This works fine, unless the formula is put in the same column as the column I am searching in, in which case it does some sort of circular reference or something. Is there a formula I can use instead which will work when placed in the same column as it searches in?</p>