title: Including a non-adjacent cell in a Range (series) in the XIRR formula
body: <p>I am using the XIRR formula as follows:</p>
  
  <pre><code>=XIRR(E$11:E17,B$11:B17)
  </code></pre>
  
  <p>but need to add an additional non-adjacent cell to the Range of values and dates. </p>
  
  <p>My first attempt:</p>
  
  <pre><code>=XIRR((E$11:E17,H17),(B$11:B17,B17))
  </code></pre>
  
  <p>resulted in <code>#VALUE</code></p>
  
  <p>I have attempted to do it using the CHOOSE function as follows:</p>
  
  <pre><code>=XIRR(CHOOSE({1,2},E$11:E17,H17),CHOOSE({1,2},B$11:B17,B17))
  </code></pre>
  
  <p>But this is not working to produce the correct results.</p>
  
  <p>I cannot figure out how to add one cell onto the end of the range. The following did work to give correct results but isn't going to work for me, as I need to use a range and individual cell, not all individual cells</p>
  
  <pre><code>=XIRR(CHOOSE({1,2,3},E11,E12,H13),CHOOSE({1,2,3},B11,B12,B13))
  </code></pre>
  
  <p>Thanks for your help.</p>