I have seen the thread on using IRR with non adjacent cells, but the some
range referencing does not work with XIRR function. I am using the following
:
IRR(($J$4:$J$4;J5)) this works but
XIRR(($J$4:$J$4;J5);($H$4:$H$5)) returns #VALUE!