Need a concept for the formula used

[ekramulmostaqui]

Hi,

I have two columns. One column contains the date and the other column contains text. So, my concept is that in the new column "Process", if the date is not missing, then it would be text value. If the date is missing, it would be the value of the previous row of the "Process" column.

Date	Text
12.01.2023	A
	BA
	BBS
13.01.2023	B
	CV

Output Should be,

Date	Text	Process
12.01.2023	A	A
	BA	A
	BBS	A
13.01.2023	B	B
	CV	B

I have written the following formula. But it shows the error for the date missing value. Can anyone tell me what the problem is?

Date	Text	Process
12.01.2023	A	A
	BA	error
	BBS	error
13.01.2023	B	B
	CV	error

Regards,

Ekram

[Ahmedx · Accepted solution]

watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RilB4dgXehRDUHvs_?e=21ggVw

[ekramulmostaqui]

Very nice demonstration. It worked. Thanks a lot.