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
<colgroup><col span="2"></colgroup><tbody>
</tbody>
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>