/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

1 vote118 views2 answers
Get all column names from excel vba
VBA
0 vote124 views1 answer
Vba leading zeros in string
VBA
1 vote124 views1 answer
Excel vba get column name from number
VBA
0 vote129 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
3 votes144 views1 answer
Extract word in a text in excel
VBA
3 votes129 views1 answer
Excel insert blank row for value change in column
VBA
0 vote129 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote123 views1 answer
Enable macros on opening workbook vba
VBA
0 vote124 views1 answer
Vbscript abs
VBA
0 vote134 views1 answer
Power query M substract minimum value of column -dax
VBA