Row Number of Last Numerical Cell

[RedMan7]

Hello All,

I am having a bit of trouble, and am hoping someone can help me. I have a table below containing two columns: One with a planned submission, and another with an actual submission. If the submission isn't submitted, I input "Not Submitted" and if it is not required I input "Not Required"

What I need to do is get the date of submission of the last submitted. Is there a formula I can use here to get the Date of the "Last Actual Submission" that is a date? I.e. Automate this for any kind of table - In this case, it would be 03/01/2019 as the last items are not required.

Thanks!

Planned Submission Actual Submission

17/12/2018	11/01/2019
17/12/2018	Not Required
17/12/2018	Not Submitted
17/12/2018	Not Submitted
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	04/12/2018
17/12/2018	03/01/2019
17/12/2018	Not Required
17/12/2018	Not Required

<colgroup><col span="2"></colgroup><tbody>
</tbody>

 

[Johnny C]

I think you need a helper column. in C2
=IF(LEFT($B2,1)="N","",ROW()-1) and copy down
Then your formula would be
=OFFSET($B1,MAX($B:$B),0)

 

[FormR]

Hi, this will return the last numeric value (including dates) in column B.

=LOOKUP(9.99999999999999E+307,B:B)

 

[RedMan7]

Thank you all, I think I have figured it out for my purposes just using a Max function.