Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Query function to get last row in Google Sheets

I have a sheet where data is updated daily.

however, the last integer often ends in between row 131 to 133.

how do I run a query function to display the last integer in row 1 column C?

I cannot do a simple =A131 on C1 because it can be on A133 the next day.

1 1

images: https://i.sstatic.net/eJAAF.jpg

like image 400
sheetsquestions Avatar asked Sep 17 '25 00:09

sheetsquestions


1 Answers

paste in C1 cell:

=QUERY(A1:A, "offset "&COUNTA(A1:A)-1, 0)

0

like image 88
player0 Avatar answered Sep 19 '25 13:09

player0