excel formula for last non-empty cell in a column

The solution for “excel formula for last non-empty cell in a column” can be found here. The following code will assist you in solving the problem.

Get the Code! 
‘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)

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts

vba ternary

Bym0nxt3r

The solution for “vba ternary” can be found here. The following code will assist you in solving the problem.Thank you for using DeclareCode; We hope you were able to resolve the issue. More questions on [categories-list]

System.InvalidOperationException: ‘Row associated with the currency manager’s position cannot be made invisible.

Bym0nxt3r

The solution for “System.InvalidOperationException: ‘Row associated with the currency manager’s position cannot be made invisible.” can be found here. The following code will assist you in solving the problem.Thank you for using DeclareCode; We hope you were able to resolve the issue. More questions on [categories-list]