Ali M.
Ali M.
Programming language:VBA
2021-03-26 22:54:36
0
Q:

formula for last filled cell in a column

Rohcana
Rohcana
Code: VBA
2021-09-02 13:11:32 
'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)
5

Tags

Related

New to Communities?

Join the community