Hello,
I would appreciate your help on the below case where I have to calculate XIRR for multiples dates considering that market values and flows are located under the same columns.
Example:
In cell F9 I need to merge dates from (1) C3 to C6 plus C9 and (2) Initial Market Value, D3, plus Flows, D4:D6, plus Market Value for the corresponding date, which is D9 in this case. So basically under dates I need to have "C3:C6 & C9" and under values "D3:D6 & D9".
Is that possible to achieve with array type of formula?
Thank you in advance!
Bookmarks