/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

1 vote164 views1 answer
Excel vba compare 2 rows
VBA
1 vote166 views1 answer
Excel vba make cell visible
VBA
0 vote185 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote176 views1 answer
Vba sheet visible
VBA
0 vote188 views1 answer
Vba open report
VBA
0 vote177 views1 answer
Excel filter by date not working vba
VBA
0 vote218 views1 answer
How to call gcd in vba
VBA
0 vote157 views1 answer
Vba copy paste value only
VBA
0 vote194 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote177 views1 answer
Vbscript abs
VBA