Forum Discussion

Nilkanth's avatar
Nilkanth
Frequent Visitor
8 years ago
Solved

Alternative formula to replace the value based on previous cell value

Hi, I used below formula to replace the value based on theprevious value using Index column but it takes too much time to load and when I apply the next step it show the error. Is there any alternat...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Nilkanth's avatar
Nilkanth
Frequent Visitor
8 years ago

Hi,

 

I have a table which has 10 columns. One of the column has duplicate value for the same month which I want to replace with "0". Please look at the highlighted cell value which I want to replace with "0" because those are duplicate value. I can't run remove duplicate function because it will eliminate entire row, which has some data I may not want to lose.

 

 

Thank you!