Compare dates but some rows are null, fill in null date cells with date last used to match

[ericren]

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

[binuacs]

@ericren One way of doing this

[nagakavyasri]

Try this