D
D
dollar2019-08-14 02:47:54
Google Sheets
dollar, 2019-08-14 02:47:54

How to find out the size of a table (column) if there are empty cells?

There is some data in column A, but not solid, but with empty cells. The number of the first row is known - it is equal to 1. But the number of the last row is not known in advance: today it is 123, and tomorrow it may be 129, and when a new cell is added, lines 124-128 will be empty. The column size must be determined by the last value in the column. How to do it?
Preferably without scripts.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Bcoon, 2019-08-14
@dollar

=ARRAYFORMULA(MAX(ROW(A:A)*(A:A<>"")))

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question