title: Append value to result of FILTER function in order to call XIRR function
body: <p>I'm trying to call the <code>XIRR</code> function using a filtered array of data, but I need to append one additional value to each array</p>
  <p>The baseline idea is the following formula that gathers the cashflow/date arrays from the K/A columns using the <code>FILTER</code> function:</p>
  <pre><code>=XIRR(FILTER(K2:K1000,C2:C1000=M2),FILTER(A2:A1000,C2:C1000=M2))
  </code></pre>
  <p>However, the arrays returned by <code>FILTER</code> are missing data for the current day that exists elsewhere in the sheet.  So I want something similar to:</p>
  <pre><code>=XIRR(FILTER(K2:K1000,C2:C1000=M2) + {Q2},FILTER(A2:A1000,C2:C1000=M2) + {TODAY()})
  </code></pre>
  <p>Where <code>Q2</code> and <code>TODAY()</code> are the additional pieces of data.  Obviously the above formula doesn't actually work, but is there any way to append data to an existing array like that directly inside a formula(without using a scratch area)?</p>