Space Ape wrote:
How can I get the Last row of the column containing blank cells between
non-blank cells.

Example:

the data in a column is

1
(blank cell)
2
3
4
5

How can I get last row of this column?

Thanks in advance for your replies.


The native row number wtr the last numeric value:

=MATCH(9.99999999999999E+307,A:A)

if the column of interest is A.

To fetch the last numeric value itself:

=LOOKUP(9.99999999999999E+307,A:A)