/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 vote184 views1 answer
VB Error Code BC30201
VBA
0 vote229 views1 answer
Excel vba delete columns in range
VBA
3 votes180 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote212 views1 answer
Vbnet check if string is only letters
VBA
1 vote183 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
5 votes189 views1 answer
Vba low word from Long Integer
VBA
0 vote187 views1 answer
Convert unix to date vba
VBA
3 votes215 views1 answer
Excel vba make long from two shorts
VBA
0 vote206 views1 answer
Iterate all file in a folder vba
VBA
0 vote188 views1 answer
Excel vba DisplayAlerts
VBA