Get previous row value when the value is null

[Anonymous]

Dear Experts,

I would like to copy the previous value when the current row value is null.

I tried the peek/previous functions but it is working only for the first blank row and it doesn't carry that logic to the next blank row.

I have Billing Lines and customers.For few billing lines I don't have the Customer details in which I want to copy the Customer number from the previous billing line.

Since the data is huge,could you please suggest the best way to achive this logic?

Thanks & Regards

Jeba

[Anonymous]

Hi Peter,

I am trying this logic now and will get back to you soon

Regards

Jeba

[Anonymous]

Hi Naresh,

This was the same logic I tried earlier,but not working

Regards

Jeba

[NareshGuntur]

Hi Jeba,

Please check if this is what you want.

I have used the Sample.xlsx(which you have shared) as source.

Cheers,

Naresh

[NareshGuntur]

Hi Jeba,

Please let me know if this is working as expected or if you are looking for a different solution.

[Anonymous]

Hi Naresh,

This is exactly what I was looking for.

However this logic doesn't work with the large data.Thats where I struck up.

I am trying the logic given by Peter.

I will keep you posted.

Thanks a lot for your help

Thanks & Regards

Jeba