title: Query function to get last row in Google Sheets
body: <p>I have a sheet where data is updated daily.</p>
  
  <p>however, the last integer often ends in between row 131 to 133.</p>
  
  <p>how do I run a query function to display the last integer in row 1 column C?</p>
  
  <p>I cannot do a simple <code>=A131</code> on C1 because it can be on A133 the next day.</p>
  
  <p><img src="https://i.imgur.com/1r2ohza.png" alt="1">
  <img src="https://i.imgur.com/F4e9TVo.png" alt="1"></p>
  
  <p>images: <a href="https://imgur.com/a/pravwxJ" rel="nofollow noreferrer">https://imgur.com/a/pravwxJ</a></p>