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
[TABLE="width: 290"]
<colgroup><col span="2"></colgroup><tbody>[TR]
[TD]17/12/2018[/TD]
[TD]11/01/2019[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]Not Required[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]Not Submitted[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]Not Submitted[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]04/12/2018[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]03/01/2019[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]Not Required[/TD]
[/TR]
[TR]
[TD]17/12/2018[/TD]
[TD]Not Required[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.