/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 vote233 views1 answer
Putting marquee in vb.net
VBA
0 vote204 views1 answer
How to sort datagridview in vb.net
VBA
0 vote248 views1 answer
Remove series name from legendvbnet
VBA
32 votes335 views2 answers
Excel vba column letter
VBA
1 vote214 views1 answer
Vba listindex select multiple items vba
VBA
0 vote265 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote256 views1 answer
Vba add spaces
VBA
0 vote242 views2 answers
Do until loop vba
VBA
8 votes270 views1 answer
Vba make integer
VBA
0 vote253 views1 answer
Vba range clear formatting
VBA