/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 vote190 views1 answer
Vba select file in folder
VBA
1 vote167 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote228 views1 answer
Thread sleep vb
VBA
5 votes219 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote231 views1 answer
Power query M substract minimum value of column -dax
VBA
1 vote223 views1 answer
How to check is the value enterd is a number or text in vba
VBA
2 votes221 views1 answer
Vba file from path
VBA
0 vote226 views1 answer
Excel vba unlock sheet without password
VBA
1 vote232 views1 answer
Vba login website
VBA
0 vote230 views1 answer
Vba collection contains
VBA