R
Ray D.
What I want to do is simple... I have a set of data in a single
column, but at some points this data resets to 0. I don't want this,
so my idea for fixing the data is to add the current cell value to the
cell value before 0.
I'll try and illustrate this with an example...
Say my column looks as follows...
1
2
3
4
5
6
7
8
0
1
2
3
4
The zero indicates a point where the data stream was inadvertently
reset. So the optimal solution would be to add the value '8' to the
remainder of the cell values to readjust, which would look as follows:
1
2
3
4
5
6
7
8
8
9
10
11
12
Problem is, when I try and add the current cell to the formula, it
gives me a circular reference warning. I kind of need to get around
this, so what is the best way?
column, but at some points this data resets to 0. I don't want this,
so my idea for fixing the data is to add the current cell value to the
cell value before 0.
I'll try and illustrate this with an example...
Say my column looks as follows...
1
2
3
4
5
6
7
8
0
1
2
3
4
The zero indicates a point where the data stream was inadvertently
reset. So the optimal solution would be to add the value '8' to the
remainder of the cell values to readjust, which would look as follows:
1
2
3
4
5
6
7
8
8
9
10
11
12
Problem is, when I try and add the current cell to the formula, it
gives me a circular reference warning. I kind of need to get around
this, so what is the best way?