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.
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
Thanks for quick response, its working well