/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

8 votes282 views1 answer
Excel vba make word from bytes
VBA
0 vote210 views1 answer
Vba keep command window open
VBA
0 vote178 views1 answer
Excel autofilter vba
VBA
1 vote197 views1 answer
Export datagridview to excel vb.net
VBA
6 votes202 views1 answer
Excel vba isalpha
VBA
0 vote203 views1 answer
Regex numeric digits
VBA
0 vote166 views1 answer
Vba select file in folder
VBA
3 votes194 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote212 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote214 views1 answer
Group controls programmatically vb
VBA