Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add to current cell value
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CURRENT TIME IN DESTINATION CELL IF SOURCE CELL IS TEXT | Excel Discussion (Misc queries) | |||
How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
Can I automatically enter the current date or current time into a | New Users to Excel | |||
Send cell value to custom pane based on current cell/row? | Excel Discussion (Misc queries) |