Hi All,
See below.
I want all rows with M DATE > T DATE.
But if M DATE is null, I want it to use the Date next to it with the same account number.
The 1st empty Cell in M Date, should populate with 4/18/23 based on the account number and proximity to the cell above.
| ACCOUNT | T DATE | M DATE |
| 23232 | 4/17/2023 | 4/18/2023 |
| 23232 | 4/17/2023 | 4/18/2023 |
| 23232 | 4/17/2023 | |
| 23232 | 5/19/2023 | 4/18/2023 |
| 55555 | 5/19/2023 | |
