title: With excel formula A1/$A$1, change $A$1 ref when another cell value changes
body: <p>In the following (very simplified) example, I'd like to calculate <code>B1/$B$1</code> for row 1, and repeat for each row (i.e. <code>B2/$B$1</code>, <code>B3/$B$2</code> etc). When the value of column A changes, I need it to change (in the example below) to <code>B4/$B$4</code> on row 4 and then <code>B6/$B$6</code> in row 6 (and so on).</p>
  
  <pre><code>    A    B 
  -----------
  1|  2    2  
  2|  2    5  
  3|  2    8  
  4|  3    2  
  5|  3    4  
  6|  4   15  
  7|  4    3  
  8|  4    7  
  </code></pre>
  
  <p>Hope this makes sense. Suggestions for any formulas/macros very much appreciated.</p>