/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

5 votes296 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote292 views1 answer
Excel vba move down to next visible cell
VBA
0 vote295 views1 answer
WGET FTP
VBA
0 vote302 views1 answer
Add text to combobox drop down vb
VBA
3 votes284 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote316 views1 answer
Sort dictionary by key vba
VBA
0 vote306 views1 answer
Vba listbox remove all items
VBA
0 vote277 views1 answer
Vbs send keys
VBA
0 vote293 views1 answer
Vb get ip address
VBA
0 vote335 views1 answer
Application.ExecutablePath VB.NET
VBA