/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 vote158 views1 answer
Vba character ascii code
VBA
0 vote150 views1 answer
Vb get ip address
VBA
0 vote159 views1 answer
How to mount floppy disks in vb.net
VBA
1 vote165 views1 answer
Sort using vba
VBA
2 votes158 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
8 votes206 views1 answer
Excel vba make word
VBA
0 vote153 views1 answer
Excel vba disable mouse click
VBA
6 votes155 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote153 views1 answer
Visual basic msdos
VBA
0 vote162 views1 answer
Putting marquee in vb.net
VBA