title: Temporary variables in Excel formulas
body: <pre><code>=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),-4,2+MATCH(MIN(OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,3,1,10)), OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,3,1,10), 0),1,1)
  </code></pre>
  
  <p>in the above example (don't consider what it does), I have to evaluate twice the exact same expression : <code>OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,3,1,10)</code></p>
  
  <p>Is there a way to add variables on the fly in formulas? So that we store once the result and simply refer to it later on within the formula ? This is an example in which the cost of computing several times the same thing has no impact, but what about more costly calls or computations ?</p>
  
  <p>I'm thinking of some feature that are existing in recursive functional languages such as Caml.</p>