/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 vote195 views1 answer
Power query M substract minimum value of column -dax
VBA
-1 vote181 views2 answers
How close excel through visual basic
VBA
1 vote200 views1 answer
Sort using vba
VBA
0 vote172 views1 answer
Vba first cell in range
VBA
0 vote202 views1 answer
Excel vba first column in range
VBA
1 vote193 views1 answer
Add rows to datagridview vb.net
VBA
0 vote197 views1 answer
Tester si une case est vide vba
VBA
0 vote245 views1 answer
Excel vba add reference programmatically
VBA
2 votes133 views1 answer
Excel vba pause
VBA
0 vote188 views1 answer
Show unix time in vba
VBA