/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 vote330 views1 answer
Vba remove last vbcrlf
VBA
0 vote325 views1 answer
Get current year vb
VBA
1 vote285 views1 answer
Vba listindex select multiple items vba
VBA
0 vote306 views1 answer
Vba word open document read only
VBA
7 votes354 views1 answer
Excerl vba array to range
VBA
0 vote318 views1 answer
Vbscript Trim
VBA
0 vote335 views4 answers
Jwt token vb.net validation
VBA
0 vote328 views1 answer
Afficher un message d'erreur vba
VBA
0 vote306 views1 answer
Hello world vb.net
VBA
0 vote340 views1 answer
Vba character ascii code
VBA