/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 vote223 views1 answer
Vba code to select image in sheet
VBA
0 vote209 views1 answer
Excel vba extract year
VBA
0 vote201 views1 answer
Vba shape transparent
VBA
0 vote221 views1 answer
Regex numeric digits
VBA
0 vote226 views4 answers
Jwt token vb.net validation
VBA
0 vote224 views1 answer
Vba search string position
VBA
0 vote215 views1 answer
Search combobox items vb.net
VBA
5 votes232 views1 answer
Excel vba last byte from INTEGER
VBA
1 vote197 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote216 views1 answer
Vba html document reference
VBA