Is there any way to concatenate two column ranges in memory (i.e. without using intermediate cells)?
The short version is i’m trying to do something analogous to
+ is the concatenation of both ranges, which I made up just as explanation
So in this case I concatenate the two ranges A3:A5 with C7:C10 which would give [A3, A4, A5, C7, C8, C9, C10]
The long version is that I am trying to calculate
XIRR, which requires that the balance of the account is in the same cell range as the flows but the balance needs to be negative so I would like to concatenate the range of flows with the negative of the balance
This would allow me to do something like
=XIRR(A1:A5 + (-1 * M7), C1:C5 + N7) so the first parameter would be [A1, A2, A3, A4, A5, -M7]