Lookup / refer to highest Row number in a column

Only in a single column or in all columns?

And you want VBA or Excel Function?

Hi.

Does the column in question contain text, numbers, or perhaps a mixture of both?

Also, are there any null strings (""), e.g. a result of formulas within those cells?

Regards

Try
=IF(COUNTA(A:A),MAX(IFERROR(MATCH(10^15,A:A),0),IFERROR(MATCH(REPT("z",15),A:A),0)),"")

Please Login or Register  to view this content.

or
=IFERROR(LOOKUP(2,1/(A:A<>""),ROW(A:A)),"")

Originally Posted by nflsales

Please Login or Register  to view this content.

This is why I asked if there were any null strings ("") within the range, since this may well fail if there are.

Originally Posted by nflsales

=IFERROR(LOOKUP(2,1/(A:A<>""),ROW(A:A)),"")

This will work, though it is having to process more than a million cells, so is incredibly inefficient.

Regards