/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

0 vote311 views1 answer
Vba select file in folder
VBA
0 vote312 views1 answer
Vba string start with
VBA
0 vote255 views10 answers
Vba excel create event log
VBA
-1 vote318 views2 answers
How close excel through visual basic
VBA
0 vote331 views1 answer
Vba code for cutoff time
VBA
1 vote344 views2 answers
Get all column names from excel vba
VBA
0 vote321 views1 answer
Excel vba scroll to cell
VBA
-1 vote336 views2 answers
Excel vba delete empty rows
VBA
0 vote377 views1 answer
Excel vba protect scenarios
VBA
0 vote337 views1 answer
Excel vba calculate
VBA