Can someone help me write a formula in the attached file so that the XIRR formula ignores the zeros before the first negative number?
Can someone help me write a formula in the attached file so that the XIRR formula ignores the zeros before the first negative number?
Last edited by ZM22; 08-12-2021 at 03:55 PM.
Please try
=XIRR(FILTER(C5:C29,C5:C29),FILTER($B5:$B29,C5:C29))
Interesting, thats a new one for me, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks