/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 vote117 views1 answer
Do until vb.net
VBA
0 vote133 views1 answer
Supprimer la valeur de celule vba
VBA
3 votes132 views1 answer
Vba make long from two words
VBA
22 votes254 views1 answer
Xl vba check for folder
VBA
0 vote118 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
4 votes113 views1 answer
Excel vba check cell not empty
VBA
0 vote161 views1 answer
Vbnet add axis labels to chart
VBA
6 votes142 views1 answer
Excel vba isalpha
VBA
0 vote128 views1 answer
Vba remove the first character of string
VBA
0 vote129 views1 answer
Excel delete ever other vba
VBA