I want fill the data in the Mar coulmn based on formula "=if(Row!=1,prev(mar,1),mar)

[GowtamK]

I want fill the data in the Mar coulmn based on formula "=if(Row!=1,prev(mar,1),mar)

Used the sort by S.no,IDs,Row.

[APrasad_Tri]

Hi @Gowtam kumar? , thank you for your question.

You have to use the FILL() function in order to get the desired output as shown below :

In the IF() function condition, use the below code:

IF(row !=1,fill(mar,-1,0),mar)

Hope this helps.

Best,

Apeksha Prasad

[GowtamK]

Thanks for quick response, its working well