/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 vote127 views2 answers
Get excel file from email attachment in vba
VBA
5 votes113 views1 answer
Excel vba high word from Long Integer
VBA
0 vote122 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote112 views1 answer
Excel vba disable screen update
VBA
5 votes76 views1 answer
Vba array worksheet.index
VBA
1 vote118 views1 answer
Excel vba to lower case
VBA
1 vote122 views1 answer
Excel vba saveas force overwrite
VBA
0 vote123 views1 answer
Change "location" of binding navigator vb
VBA
8 votes162 views1 answer
Vba make a short integer from two bytes
VBA
1 vote129 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA