/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 vote238 views2 answers
Excel vba protect cells with formula
VBA
0 vote232 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote231 views1 answer
Vba count all row
VBA
0 vote238 views1 answer
Vba html document reference
VBA
0 vote295 views1 answer
Excel vba delete columns in range
VBA
-1 vote234 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote209 views1 answer
Excel vba disable alerts
VBA
0 vote243 views1 answer
Excel filter by date not working vba
VBA
1 vote227 views1 answer
Change the first item in a queue vb.net
VBA
1 vote230 views1 answer
Excel vba get column number from column name
VBA