/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 vote366 views1 answer
.net crash app
VBA
0 vote386 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote368 views1 answer
Worksheet.pastespecial textbox
VBA
1 vote358 views1 answer
How to check is the value enterd is a number or text in vba
VBA
8 votes519 views1 answer
Vba convert 2 bytes to an integer
VBA
1 vote360 views1 answer
Sort using vba
VBA
0 vote367 views1 answer
Vba declare 64-bit ptrsafe
VBA
18 votes522 views3 answers
Excel-vba make integer
VBA
0 vote375 views1 answer
Vba listbox remove all items
VBA
8 votes436 views1 answer
Excel vba determine number of elements in a 2D array
VBA