/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

1 vote127 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote146 views1 answer
Excel web scraping
VBA
0 vote143 views1 answer
Regex numeric digits
VBA
0 vote123 views1 answer
Open application from vbnet
VBA
0 vote148 views1 answer
Excel vba protect scenarios
VBA
31 votes256 views1 answer
Excel vba function to convert column number to letter
VBA
1 vote133 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote144 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote130 views1 answer
Vba static variable
VBA
0 vote137 views1 answer
Filesystemobject vba reference
VBA