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.
images: https://i.sstatic.net/eJAAF.jpg
paste in C1 cell:
=QUERY(A1:A, "offset "&COUNTA(A1:A)-1, 0)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With