/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 vote166 views1 answer
Add items to combobox vb.net
VBA
0 vote196 views1 answer
Excel vba protect scenarios
VBA
0 vote165 views1 answer
Vbnet line graph smooth lines
VBA
0 vote185 views1 answer
Vba variable number of arguments
VBA
0 vote165 views1 answer
Vba change named range address
VBA
0 vote175 views1 answer
Ribbon show/hide
VBA
0 vote179 views2 answers
Excel vba number format file size
VBA
7 votes176 views1 answer
Vba array declaration
VBA
0 vote182 views1 answer
Vba copy file
VBA
0 vote177 views1 answer
Vba type variable
VBA