/VBA/Excel formula for last non-empty cell in a column

Excel formula for last non-empty cell in a column

'Excel formulas.

'Last filled cell in column A, confirm with Ctrl-Shift-Enter:
=INDEX(A:A,MAX((A:A>"")*(ROW(A:A))))


'Row number of last filled cell in column A, confirm with just Enter:
=INDEX(MAX((A:A>"")*(ROW(A:A))),1)

Source: academy.excelhero.com

Similar codes

8 votes393 views1 answer
Vba make integer
VBA
0 vote315 views1 answer
Vbide vbproject reference
VBA
-1 vote365 views1 answer
How save excel through visual basic
VBA
0 vote339 views1 answer
Vba file chooser
VBA
0 vote343 views1 answer
VB Error Code BC30201
VBA
6 votes376 views1 answer
Excel vba get the path of current workbook
VBA
-1 vote341 views2 answers
Excel vba delete empty rows
VBA
5 votes376 views1 answer
Excel vba right word from Long Integer
VBA
0 vote344 views1 answer
Excel vba StartUpPosition
VBA
0 vote350 views1 answer
Excel vba ternary
VBA