/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 vote227 views1 answer
Putting marquee in vb.net
VBA
0 vote226 views1 answer
Vbnet get file name from path
VBA
0 vote257 views1 answer
Iterate all file in a folder vba
VBA
3 votes240 views1 answer
Excel vba change format of cell
VBA
0 vote221 views1 answer
Vba dictionary length
VBA
3 votes242 views2 answers
Excel "vba" match last value
VBA
0 vote239 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote243 views1 answer
Power query M substract minimum value of column -dax
VBA
1 vote217 views1 answer
How to do error handling in access vba
VBA
4 votes239 views1 answer
Excel vba determine number of elements in an array
VBA