Is there a way to select the lowest filled cell in Google Sheets?
Example: every row represents one data point, and you always want to use the latest one
yeah if you don't have that assumption then you could have a row next to the target row and drag down a formula there like =if(b15="",c14,b15) and then take max(C:C)
