title: Google Sheets using MATCH to find non-numeric or blank cells
body: <p>Given a column of data here:</p>
  
  <pre><code>13
  4
  76
  8
  
  56
  4
  
  7
  3
  </code></pre>
  
  <p>Is there a way to use MATCH() function (or similar) such that it will return the row number of the last blank or non-numeric row it finds? I will accept any solution that can search for either blank of non-numeric</p>
  
  <p>=MATCH("", A:A) returns #N/A instead of 8</p>
  
  <p>If not, is there a way to achieve this without using a script?</p>
  
  <p>Usage:
  I'm essentially looking for a way to create a range from the last blank cell to the current row.</p>