I am looking for a pattern that allows to use a non contigous cells
reference.
I have a XIRR formula with syntax (Values, Dates, Guess).

This is my investment simple example:

A1:A3 Values, B1:B3 Dates
A100:A103 Values, B100:B103 Dates

I need to calculate XIRR for this investment but without reorganizing
the sheet which is much more complex then in this example.

Thanks in advance,
Tomek Polak