title: Find Last and Second Last value in a column from a range in Excel
body: <p>I need to calculate the difference of second last value from the last/latest value in a column from a range in Excel.</p>
  
  <p>For Example</p>
  
  <pre><code>1305
  1309
  1405
  1506
  </code></pre>
  
  <p>I need to calculate the difference between 1506 and 1405
  Again in next month the values may be</p>
  
  <pre><code>1305
  1309
  1405
  1506
  1603
  </code></pre>
  
  <p>Then I need to auto calculate 1603-1505</p>