HI Guys i am in need of a simple formula to increment a cell content by the previous cell value +1. I have done it in the past but have slept since then. Hope to resolve this before whisperer catches me in the forum again lol
I may be missing something but if the value in A1 is 137 (for example) then in A2 enter the formula
If you want to populate a column with a set of increasing values then enter the first few. Hover the cursor over the bottom right of that range until the cursor changes to a +. Hold down the left mouse button and drag down.
Sorry unclear information given. The sheet is used on a daily basis and the references change from day to day. ie, Monday start D?????? and increases To D?????? the same template is used for the rest of the week with e8 containing d?????? to D??????