/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

31 votes369 views1 answer
Vba how to convert a column number into an Excel column
VBA
1 vote277 views1 answer
Excel vba last column in range
VBA
0 vote306 views1 answer
Vba userform textbox wrap text
VBA
0 vote259 views1 answer
Docker vboxmanage not found
VBA
0 vote290 views1 answer
Excel vba copy range with filter
VBA
0 vote272 views1 answer
How to use if condition in time vba
VBA
0 vote301 views1 answer
Move bindingnavigator vb
VBA
0 vote230 views1 answer
How to sort datagridview in vb.net
VBA
0 vote259 views1 answer
Remove first character from string vb
VBA
1 vote264 views1 answer
If inputbox cancel vba
VBA