Calculating XIRR on Non-Contiguous Rows and Columns based on Criteria

Calculating XIRR on Non-Contiguous Rows and Columns based on Criteria

Dear Forum,

I am trying to calculate the XIRR for Multiple Investments done over different dates and stored in non-contagious rows and the last value of the investment in a different column.
The XIRR requires the basic 2 Arguments the Amounts and Dates, however in my case the data is extracted from an Application where the Data is SORTED basis the Investment Date as there are Multiple Investments done in different Mutual Funds its difficult to get a continuous range to pass in the XIRR Function also the Latest Value of the Investment is not withdrawn but a notional amount which is a separate column so can something be done to use the XIRR Function for each Mutual Fund Separately.

Without Sorting the Data, can this be achieved using Formulae also if any VBA option would also be Welcome which can Joi the Multiple Non-Contiguous Ranges and Column Ranges to be used in XIRR.

Please find my attached file for reference.

Thanking you in anticipation.

Regards
e4excel