Is there a way to efficiently obtain the row index of the last non-empty cell in a column in Google Sheet?
The column may contain blank cells in between or cells that fail isblank() but checks ="".
Example
App Script solution is ok but would be cumbersome. But note that other columns of the same sheet contain non-empty cells of larger rows.
I understand tocol is great for retrieving the content of the last non-empty cell. Is there a built-in function that can do for row index of that cell?
If it is text data type column then use-
=MATCH("zzz",A:A)
If the column is number data type then use-
=MATCH(99^9,H:H)
1