title: Excel formula to calculate difference between a column values
body: <p><a href="https://i.stack.imgur.com/qnwUj.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qnwUj.jpg" alt="Excel sheet"></a></p>
  
  <p>how to calculate difference between a column value and column value in previous row. This should be calculated for entire column.</p>
  
  <p>Column G should represent difference between rows of column E.</p>
  
  <p>E.g.</p>
  
  <p>G3 = E3 - E2</p>
  
  <p>G4 = E4 - E3</p>
  
  <p>G5 = E5 - E4</p>
  
  <p>G6 = E6 - E5</p>
  
  <p>and so on for entire column.</p>
  
  <p>Similarly column H should represent difference between rows of column F.</p>
  
  <p>E.g.</p>
  
  <p>H3 = F3 - F2</p>
  
  <p>H4 = F4 - F3</p>
  
  <p>and so on for entire column.</p>