title: MS Excel : changing the counter in formula to some other than the one Excel has assumed
body: <p>An excel formula looks like this </p>
  
  <pre><code>=", " &amp;($C$1)+1
  </code></pre>
  
  <p>Here's how the data looks  when I paste special --> forumulas </p>
  
  <pre><code>    1
  , 2
  , 3
  , 3
  </code></pre>
  
  <p>I want it to increase the LAST Number +1 in the counter . 
  Something like </p>
  
  <pre><code>    1
  , 2
  , 3
  , 4
  </code></pre>
  
  <p>I can of course fix it many "work-around" ways like having 1 more column for the step up counter and then using it in the formula. Here Excel BY  DEFAULT will step up the counter on Column C1 like this</p>
  
  <pre><code> =", " &amp;(C1)+1
  </code></pre>
  
  <p>and increase C1 to C2 C3 ..Cn  on a  "paste special" ..unless you freeze it with $C$1 but then it's not sensible enough to consider the last +1 as the counter and use that. So the counter remains the same and the value is the same.
  How to tell excel to use the last + 1 as the counter </p>