Detect Last Filled Row

[rwmill9716]

I have dates in Column A that are constantly being added to. I need a formula approach to detecting the last filled cell in column A (or the first empty cell in column A) and returning its row number.

 

[mumps]

Try: =SUMPRODUCT(MAX(ROW(A:A)*(A:A<>"")))

 

[rwmill9716]

Works perfectly. Thanks, mumps

 

[MARK858]

Try

=MATCH(9.99999999999999E+307,A:A)

 

[Fluff]

Another option
=MATCH(TRUE,INDEX(A:A="",0),0)

 

[mumps]

Glad to help.