/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 vote208 views1 answer
Docker vboxmanage not found
VBA
5 votes245 views1 answer
Excel vba left word from Long Integer
VBA
2 votes167 views1 answer
Excel vba pause
VBA
0 vote227 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote225 views1 answer
Vba min
VBA
-1 vote228 views2 answers
Excel vba delete empty rows
VBA
0 vote205 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote207 views1 answer
Excel protect cells with formulas
VBA
0 vote239 views1 answer
Excel vba set cell value to empty
VBA
1 vote214 views1 answer
Excel vba last column in range
VBA